hi gurus,
any body have any idea of how to join
these querries.
i want to select from two different
tables namely dba_data_files call it A and dba_free_space call it B. but
the columns being selected are same i.e. tablespace_name and bytes from both
tables.
i want to select in a single querry
as..
tablespace_name
bytes1
bytes2
--
--
--
--
--
--
--
--
--
where bytes1 is sum(bytes) group by tablespace_name in table a.
and bytes2 is sum(bytes) group by tablespace_name in table b.
Saurabh Sharma
<A
href="mailto:saurabh.sh_at_usa.net">saurabh.sh_at_usa.net<A
href="
http://www.geocities.com/saurabh00pc/stride.html">
http://www.geocities.com/saurabh00pc/stride.html
Received on Tue Jul 03 2001 - 05:50:36 CDT
