--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<fbsupport@...> wrote:

>
> Hi Adam,
>
> > select *
> > from a
> > left join (b on (a.id = b.aid) join c on (b.id = c.bid))
> >
> > which is of course invalid syntax. The closest you can get under
> > Firebird 1.5 (apart from the view) is to use left joins, then to use a
> > where clause to enforce the inner join.
>
> Note that this is possible in every FB version:
>
> SELECT
> *
> FROM
> a
> LEFT JOIN (b join c ON (c.id = b.bid)) ON (a.id = b.aid)
>

Arno,

That is great, it was a weakness that bothered me, but that I would
use a view to work around. How does this affect the PLAN. Normally I
would expect the left join to use 'a' first, but does this change here?

Adam