Hi,
I need to query with the SQL statement as below. However, i get error message if using DAO, it is fine if I am using DataEnvironment. Why?
SELECT SUM(TTotal), SUM(PTotal)
FROM
(SELECT SUM(addlog.tran_bal) AS TTotal,
SUM(0) AS PTotal
From Addlog Union
SELECT SUM(0) AS Total,
SUM(eftlog.tran_bal) AS PTotal
FROM eftlog)Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
