Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
SQL Statement :