Hi Adam,

>> SELECT
>> *
>> FROM
>> a
>> LEFT JOIN (b join c ON (c.id = b.bid)) ON (a.id = b.aid)
>
> 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?

It doesn't affect the PLAN. The inner join order between b and c can be chosen and that result will
be outer joined with a.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info