From ssharma1@fcsltd.com Tue, 03 Jul 2001 03:50:36 -0700 From: "Saurabh Sharma" Date: Tue, 03 Jul 2001 03:50:36 -0700 Subject: urgent..! how to combining 2 querries... Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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   saurabh.sh@usa.nethttp://www.geocities.com/saurabh00pc/stride.html