Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: count record from two tables with duplicate check

Re: count record from two tables with duplicate check

From: sim <jmenker_at_muenster.de>
Date: 14 Sep 2005 01:20:39 -0700
Message-ID: <1126686039.446382.147310@o13g2000cwo.googlegroups.com> 





Here's another one:



SELECT (SELECT COUNT(*) FROM (SELECT EMP_NUM FROM A MINUS SELECT

EMP_NUM FROM B))



	+



       (SELECT COUNT(*) FROM (SELECT EMP_NUM FROM B MINUS SELECT

EMP_NUM FROM A))



	+



       (SELECT COUNT(*) FROM A,B WHERE A.EMP_NUM = B.EMP_NUM) CNT

FROM DUAL


sim
Received on Wed Sep 14 2005 - 03:20:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US