Hi John,

Does it have to be a single SQL statement. The best (and easiest) thing to do is to store the inner SELECT into a cursor and querie the outher one on the cursor like:

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 ;
    INTO CURSOR x

SELECT SUM(TTotal), SUM(PTotal)
    FROM x ;
    INTO CURSOR Result

Walter,