RE: urgent..! how to combining 2 querries...

From: jaimin <jaimin_at_rolta.com>
Date: Tue, 03 Jul 2001 06:31:00 -0700
Message-ID: <F001.0033FDFD.20010703061044@fatcity.com>

Try
this,
<SPAN
class=363061513-03072001> 
<SPAN
class=363061513-03072001> select
a.tablespace_name,sum(a.bytes),sum(b.bytes) from dba_data_files a, dba_free_space b where
a.tablespace_name=b.tablespace_name group by a.tablespace_name;
<SPAN
class=363061513-03072001> 
<SPAN
class=363061513-03072001>JAIMIN.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Saurabh SharmaSent:   Tuesday, July 03, 2001 5:16 PMTo: Multiple recipients of list   ORACLE-LSubject: urgent..! how to combining 2   querries...
  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 - 08:31:00 CDT