Re: Using union and count

From: Siva Valiveru <linuxurl_at_yahoo.com>
Date: 5 Feb 2004 16:28:57 -0800
Message-ID: <e4c73cce.0402051628.21b75637@posting.google.com>

I guess what you are looking is for

select A.ocount+B.ocount+C.ocount+d.ocount from ( SELECT COUNT(Opponent) ocount FROM databaseA_at_databaseAlink WHERE Opponent =
'A' AND Date > SYSDATE ) A,

(SELECT COUNT(Opponent)ocount  FROM databaseB_at_databaseBlink WHERE Opponent =


'B' AND Date > SYSDATE) B,

(SELECT COUNT(Opponent) ocount  FROM databaseC_at_databaseClink WHERE Opponent =


'C' AND Date > SYSDATE) C,

(SELECT COUNT(Opponent) ocount  FROM databaseD_at_databaseDlink WHERE Opponent =

'D' AND Date > SYSDATE) D;
Received on Thu Feb 05 2004 - 18:28:57 CST