RE: SQL Doubt

Posted in 1998

Leffler, Jonathan — Tue, 3 Feb 1998 14:24:15 -0800 — source: Informix-list mailing list archive (1991-1998)

It isn't documented, but there's a fighting chance that this will work: SELECT (SELECT SUM(Sal) FROM TableA) + (SELECT SUM(Sal) FROM TableB) AS Wanted FROM SysTables WHERE TabID = 1; Yours, Jonathan Leffler (jleffler@visa.com) #include <no.I.did.not.test.this.h> ---------- From: S.Sathish[SMTP:ssathish@getafix.cmc.net.in] Sent: Monday, February 02, 1998 4:25 AM Table A - name, sal Table B - name, sal I need sum(sal) from A + sum(sal) from B. Is it possible without a temp table?