Subject Re: [ib-support] Re: Query optimiser - inner join - left join
Author Svein Erling Tysvaer
Sorry Andrew,
unless there is a foreign key on PURCHREQTAGS.INC_REQN that you've hidden
from us, I have no idea why Firebird chooses such a silly plan (from what
you've told us, it certainly seems like a stupid plan).

Hope this gets others to investigate your problem and find an explaination,