How to combine 2 Select queries in 1

[leifoet]

After migration (FP=>ASP) I wish to combine 2 UNION-queries in 1 single
but I do not get a query that works.

What is the correct syntax for this ?
Thanks for tips.

sql = "SELECT Date, Description, UAKP, IVKP
FROM ddb18
WHERE memid="&FFFmem&"
UNION ALL
SELECT 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&")"

 

[dhookom]

Is this actual code?

You have sum([SumOUT[highlight #FCE94F]t[/highlight]]) rather than sum([SumOUT])

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Ed Mozley]

Also each part of the union should have the same number of columns.