Subject Re: [firebird-support] Re: detailed join mechanism description (FB 1.5)
Author Arno Brinkman
Hi Adam,

>> *
>> a
>> LEFT JOIN (b join c ON ( = ON ( = 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.

Arno Brinkman

General database development support:

Firebird open source database (based on IB-OE) with many SQL-99 features :

Support list for Firebird and Interbase users :

Nederlandse firebird nieuwsgroep :