Hi,
Any alternative SQL statement to replace the SQL statenment below?
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)
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...