Re: Sybase/Sql server Outer Joins, nulls, and counts

From: Roy Harvey <roy_harvey_at_snet.net>
Date: Tue, 24 Oct 2006 22:40:05 GMT
Message-ID: <4f5tj25i3diipaud77eqcdpcsqieq8omc9@4ax.com>

On 24 Oct 2006 15:03:57 -0700, dba_222_at_yahoo.com wrote:

>> On r.unique_id = e.unique_id
>> And e.unique_id is NULL

>Oracle would not let such a statement even compile.
>(can't have an AND without first having a WHERE)
>The compiler would give an error. In which case, I would have just
>corrected the syntax and got on with it.

There is nothing illegal about that syntax, as the AND is simply part of the ON clause. I suspect that Oracle does allow compound testing in the ON clause.

Roy Received on Tue Oct 24 2006 - 17:40:05 CDT