| Subject | Re: detailed join mechanism description (FB 1.5) |
|---|---|
| Author | Adam |
| Post date | 2006-09-03T00:20:34Z |
--- In firebird-support@yahoogroups.com, "radekok" <radekok@...> wrote:
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.
Adam
>The brackets are just for order of operations within a join condition,
> 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.
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.
Adam