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

From: (wrong string) öth <dnoeth_at_gmx.de>
Date: Wed, 27 Nov 2002 12:22:10 +0100
Message-ID: <as29sf$ndn37$1_at_ID-28204.news.dfncis.de>


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

Dieter Received on Wed Nov 27 2002 - 12:22:10 CET

Original text of this message