Na migratie van FP naar ASP probeer ik onderstaande 2 UNION-queries te combineren tot 1 enkele.
Ben al van drie naar twee geraakt maar deze laatste stap lukt niet.
Kan iemand mij helpen aan de werkende syntax hiervoor.
Dank.
sql = "SELECT Date, Description, UAKP, IVKP
FROM ddb18
WHERE memid="&FFFmem&"
UNION ALL
SELECT Date, Description, UAKP, IVKP
FROM bbk18
WHERE memid="&FFFmem&"
ORDER BY Date ASC"
sql = "SELECT Sum([SumOut]) AS TotOUT, sum([SumIn]) AS TotIN, Sum([SumIN])-sum([SumOUT]) AS Difference
FROM (SELECT Sum(UAKP) AS SumOUT, sum(IVKP) AS SumIN
FROM bbk18
WHERE memid="&FFFmem&"
UNION ALL
SELECT Sum(UAKP) AS SumOUT, sum(IVKP) AS SumIN
FROM ddb18
WHERE memid="&FFFmem&")"
Ben al van drie naar twee geraakt maar deze laatste stap lukt niet.
Kan iemand mij helpen aan de werkende syntax hiervoor.
Dank.
sql = "SELECT Date, Description, UAKP, IVKP
FROM ddb18
WHERE memid="&FFFmem&"
UNION ALL
SELECT Date, Description, UAKP, IVKP
FROM bbk18
WHERE memid="&FFFmem&"
ORDER BY Date ASC"
sql = "SELECT Sum([SumOut]) AS TotOUT, sum([SumIn]) AS TotIN, Sum([SumIN])-sum([SumOUT]) AS Difference
FROM (SELECT Sum(UAKP) AS SumOUT, sum(IVKP) AS SumIN
FROM bbk18
WHERE memid="&FFFmem&"
UNION ALL
SELECT Sum(UAKP) AS SumOUT, sum(IVKP) AS SumIN
FROM ddb18
WHERE memid="&FFFmem&")"
Laatst bewerkt: