> > > > I'm curious about where you picked up the idea of bracketing
> > > > everything including the ON .... It's not even provided as
> > > > an optional syntax under the standard, as far I can find out...
>
> You wrote:
>
> >Brackets are legal as he used them.
> >
> >I believe the brackets signal preferred join order.
>
> Can you provide a reference? AFAIU, there is no "preferred join
> order". There is a *bug* in right outer joins, where the order of
> occurrence can affect how the base stream on the right side is built
> and thus can give a different result to what the standard expects. I
> *think* this is being addressed for v.2.1 (not 2.0.1) and in the
> meantime should *not* be relied on as a "workaround" for something
> that shouldn't be logically possible.

Hmm, well not for this. Either way, it's not really important why or
how the brackets are used, the engine accepts them, so IBO should
as well.

> But for inner (exclusive) joins, there isn't any logic that makes the
> output set different according to the order in which the joins are made.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com