Adam wrote:

>>
>> SELECT *
>> FROM a
>> LEFT JOIN (b join c ON (c.id = b.bid)) ON (a.id = b.aid)
>>
>
> How does this affect the PLAN?
>

Parenthesis in a series of joins work just like parenthesis in
an arithmetic expression. The expression in parenthesis is
evaluated first, then integrated into the larger expression.
It doesn't seem to be in Helen's book, but is a normal part of
the SQL language, so she may have assumed that everyone knew
about it and concentrated on issues specific to Firebird.

Best,


Ann