Re: SELECT COUNT(*) FROM TABLE query problem

or even

select (select count(*) from table1),(select count(*) from table2)  from dual;

>
> select sum(count_table1) , sum(count_table2)
> from ( select count(rowid) , 0
> from tablename1
> union
> select 0 , count(rowid)
> from tablename2 );
Received on Sat Oct 12 2002 - 04:33:16 CDT