John,

maybe the following works for you.

SELECT SUM(addlog.tran_bal) AS TTotal, SUM(eftlog.tran_bal) AS PTotal ;
    FROM addlog FULL OUTER JOIN eftlog ON .t. = .f.

Walter,

>Hi,
> Thank you for reply. Any way to not using cursor?
>
>Thank you