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

[jaimin]

Try this,    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;   JAIMIN. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh Sharma Sent: Tuesday, July 03, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Subject: 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   [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html