From jaimin@rolta.com Tue, 03 Jul 2001 06:31:00 -0700
From: "jaimin" <jaimin@rolta.com>
Date: Tue, 03 Jul 2001 06:31:00 -0700
Subject: RE: urgent..! how to combining 2 querries...
Message-ID: <F001.0033FDFD.20010703061044@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@fatcity.com 
  [mailto:root@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@usa.net">saurabh.sh@usa.net<A 
  href="http://www.geocities.com/saurabh00pc/stride.html">http://www.geocities.com/saurabh00pc/stride.html