Re: How to get only the non-matching entries from an outer join

From: Heinz Huber <hhuber_at_racon-linz.at>
Date: Wed, 27 Nov 2002 13:45:31 +0100
Message-ID: <3de4be6d$0$28158$91cee783@newsreader02.highway.telekom.at>

Dieter Nöth wrote:
> Heinz Huber wrote:
>

>>That's interesting. We use Sybase ASA. This filters the tables based
>>on the where clause. Therefore, the above query would not give the
>>results you want.
>>
>>Anybody care to comment on the standard?

>
>
> Joe Celko posted about that several times:
> http://groups.google.com/groups?q=celko+%22Here+is+how+OUTER+JOINs+work+in+S
> QL-92%22&hl=en&lr=&ie=UTF-8&oe=UTF-8&scoring=d&selm=c0d87ec0.0210041131.3cae
> ed4b%40posting.google.com&rnum=1

Thanks for the info. I wasn't aware that Sybase violates the standard in this regards. I'll keep this in mind!

Heinz Received on Wed Nov 27 2002 - 06:45:31 CST