Thank you Barry & Odd Morten Sveås. This is what I was after - 1 column 2 rows.
Monty
bbulsara23_at_hotmail.com (barry) wrote in message news:<747f1dec.0210120133.50e148fd_at_posting.google.com>...
> 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 Mon Oct 14 2002 - 03:27:26 CDT
