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 -> 2 select(count(*)) in a query

2 select(count(*)) in a query

From: IB <Ismael.BALLO_at_NOSPAMcern.ch>
Date: Fri, 21 Sep 2001 12:18:41 +0200
Message-ID: <3BAB1401.EFC34354@NOSPAMcern.ch> 





Hi,



I've got 2 tables and I ask to myself if we can count total elements of
the 2 tables in one query



Ex : select count(*) from A + select count(*) from B.
'This' is not possible but is there a way ?



Thanks in advance.
Received on Fri Sep 21 2001 - 05:18:41 CDT












Original text of this message













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