Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> On Fri, 4 Apr 2003, Phil Mayers wrote:
>
> > ANSI SQL92 had a "table.column *= otable.ocolumn" which equates to "table LEFT
> > OUTER JOIN otable on column=ocolumn").
>
> AFAICT SQL92 has no such syntax. It's hard to do without alot of
> limitations (because join order can be important to the results of the
> query with outer joins).
Fwiw, this is MSSQL's (and presumably Sybase's?) non-standard outer join syntax.
--
greg