The following series of SQL Statement retrieve a record set of producing the payment side of cash book of Model II.
(i) SQL Statement
SELECT Narration, AccCode AS Code Amount
FROM vouchers AS v, Details AS D
WHERE type=1 AND V. VNO=D.VNO
AND AccCode Like "631∗"
(ii) SQL Statement
SELECT Narration, Code, Amount
FROM vouchers AS v, Details AS D
WHERE Type=0 AND V.VNO=D.VNO
AND code Like "631∗"
(iii) SQL Statement
SELECT Narration, AccCode AS Code, Amount
FROM vouchers AS v, Details AS D
WHERE Type=1 AND V.VNO=D.VNO
AND AccCode Like "631∗"
UNION
SELECT Narration, Code Amount
FROM vouchers AS v, Details AS D
WHERE Type=0 AND V.VNO=D.VNO
AND code Like "631∗"
This SQL Statement is source as Query D1.
(iv) SQL Statement
SELECT Code, Sum (Amount) AS Total
FROM Query D1
GROUP BY Code
This SQL Statement is saved as Query D2
(v) SELECT a. code b. Name AS (Name of Account]
IIF (a. total>0, a total Null) AS Amount
FROM Query D2 AS a, Account AS b.
WHERE a code = b code.