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

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 - 05:22:10 CST