How do i write out the sql statement into Qlik Language

[muzidube]

SELECT
B.BranchName,
a.CashDropId,
a.CashDropDate,
A.TillNumber,
A.UserId,
A.DropAmount,
A.BranchId ,
BagNumber,
E.ReferenceNo,
E.[Date] AS CashupDate

FROM CashDrop A
INNER JOIN Branch B ON A.BranchId = B.BranchID
LEFT JOIN [EnvelopDetails] E ON E.CashDropId = A.CashDropId
WHERE A.PickupDate IS NULL
AND A.CashDropId NOT IN (SELECT CashDropId FROM EnvelopDetails)
And A.BranchId IN (Select BranchId From Branches
WHERE BranchType = 'Branch'
AND ISNULL(bTouchPOS,0) = 1
AND ISNULL(UseNewCashup,0) = 1)
AND B.BranchID = 'BAB68CF2-BCE6-458B-AD26-43F58B73E753'

ORDER BY CashDropDate DESC

[QFabian]

Hi @muzidube , two things, you must create or use a LIB connection, and second, there is a statement named 'SQL',  it must be before your SELECT :

LIB CONNECT TO 'DataConnection';

SQL SELECT
B.BranchName,
a.CashDropId...

Connect Statement:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...

SQL Statement :

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...