Subject Re: detailed join mechanism description (FB 1.5)
Author Adam
--- In, "radekok" <radekok@...> wrote:
> Hi
> I'm looking for the most up-to-date SELECT syntax description for
> Firebird 1.5.
> Mainly I'm interested in a detailed join mechanism description, how the
> joins are realised in a context of multiply table joins, how are
> interpreted brackets "()"
> in a join clause and the like.

The brackets are just for order of operations within a join condition,
probably only required when wanting to mix AND + ORs in a particular
manner. You unfortunately can't define the join order through brackets
if you want to left join to the inner join two tables, although that
can be achieved with a view of the inner join.