Re: Outer Join and Group By

scthomp_at_ibm.net (Simon Thompson) wrote:

>In message <3vr0s7$lv3_at_ixnews6.ix.netcom.com> - pranav_at_ix.netcom.com
>(Gopalakrishnan Hariharan ) writes:
 

>:>Most likely possibility is that
>:> and OUTER_MONTH >= '9504'
>:>failed because of a comparison involving NULL
 

>Unlikely. I think it is a NOT NULL field.

But in an outter join, ANY joined field can be NULL.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!