Re: SQL Doubt

Posted in 1998

Paul Roberts — 3 Feb 1998 22:41:14 GMT — source: Informix-list mailing list archive (1991-1998)

In article <6b7l37$r9q$1@news.xmission.com>, S.Sathish <ssathish@getafix.cmc.net.in> wrote: > >Hi, >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? > Would you consider this to be cheating: select ( select sum(sal) from A ) + ( select sum(sal) from B ) from systables where tabid = 1 ? I'm using I-SQL 4.11 & OnLine 7.30 and it works for me. Paul (not a spokesman)