Re: 2 select(count(*)) in a query

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Fri, 21 Sep 2001 13:21:13 GMT
Message-ID: <d9Hq7.15$4Y1.14502@news1.news.adelphia.net>

select *
from (select count(*) from table1) count1,

(select count(*) from table2) count2;

So, no, it is not possible in one query. :)

"IB" <Ismael.BALLO_at_NOSPAMcern.ch> wrote in message news:3BAB1401.EFC34354_at_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 - 08:21:13 CDT