Re: wrong output from Join

Jagjeet Singh wrote:

>> ok ..
>>
>> Thanks Sybrand for prompt reply. Now its clear to me.
>>
>> Thanks,
>> Js
>>

You might want to make that an outer join as well. If there's no free space left on a tablespace, you won't see the used space either. Adding join criteria would help in preventing a Cartesian product as well. ;-)

select used.tablespace_name, used.bytes, free.bytes from
(select tablespace_name, sum(bytes) bytes  from dba_data_files
 group by tablespace_name) used,
(select tablespace_name, sum(bytes) bytes  from dba_free_space
 group by tablespace_name
) free
where
  used.tablespace_name = free.tablespace_name(+)

-- 
To reply by email remove "_nospam"