More Count(*) in one query

[JohnyHooker]

I need to SELECT about five Count(*)s in one query - something like

SELECT Count(*) FROM table1, Count(*) FROM table2; etc.

Anybody knows how to do this ??
Thanks much, Hooker

 

[tomschafer]

SELECT Count(table1.*), Count(table2.*) FROM table1, table2;

 

[Guest_imported]

select count(*) as tabel2_cnt, "table1_cnt" = (select count(*) from table1 )
from table2

 

[angiole]

The following works without creating a certesian join of table A/B/C/etc...

Select 'Table A' as table_name,
count(*)
From Table_A
UNION ALL
Select 'Table B' as table_name,
count(*)
From Table_B
UNION ALL
Select 'Table C' as table_name,
count(*)
From Table_C