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

From: Adam Hapworth <hap_at_mikomi.org>
Date: 21 Sep 2001 07:53:20 -0700
Message-ID: <a6cb04db.0109210653.5632aef2@posting.google.com>

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.

Why not do this
select count(*).A, count(*).B from A,B

Adam Received on Fri Sep 21 2001 - 09:53:20 CDT