Re: How to join when NULL is the common value ?

In article <8sqcns$rjt$1_at_nnrp1.deja.com>,   dili66_at_my-deja.com wrote:
> Hi, At a first glance it appears that when someone
> would like to join two tables over some column then
> a row with a NULL value in one of the columns will
> not be joined with a row with a NULL value in
> the other table. Do you know if there is a switch
> to allow this type of join ?
>
> Thank you.
>
> D
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

I would use the NVL function to convert the null value to something else.

select
a.col,
b.col
from
table a,
table b
where
nvl(a.col, 'NULL') = nvl(b.col, 'NULL');

--
Ethan
http://www.freetechnicaltraining.com/people_1.htm - Homepage
http://www.gnumetrics.com - Oracle Performance Monitor
http://www.qarbon.com - Create your own tutorials!


Sent via Deja.com http://www.deja.com/
Before you buy.