wrong output from Join

Hi,

 I need to calculate the sum of tablespace's size and its free size.

Select a.tablespace_name,sum(a.bytes) total_mb,sum(b.bytes) Free_mb from dba_data_files a , dba_free_space b where a.tablespace_name = b.tablespace_name group by a.tablespace_name
/

This query is givien wrong output.

Can anyone is explain it why is it giving wrong output.

Thanks,
Js Received on Fri Jul 22 2005 - 11:04:05 CDT