Re: outer-join to constant NULL

This look like an equivalent to not in (select ... ) table_B.col_3 will be null only if its value is really null or when the outer join created a virtual null row.

Dylan Cooper wrote in message <343D484D.725_at_desert.com>...
>What is the meaning of outer-joining a column to null?
>
>In particular, Oracle Discoverer 3.0 is producing SQL that looks
>like:
>
> select
> table_A.col_1
> , table_B.col_2
> from
> table_A
> , table_B
> where
> table_A.col_1 = table_B.col_1 (+)
> and table_B.col_3 (+) is null
>
>which returns all the rows of table_A regardless of the
>values in the rows of table_B.
>
>Thanks.
>dylan_at_desert.com
>
>Please cc: your response to the address above.
Received on Thu Oct 09 1997 - 00:00:00 CEST