Subject Re: LEFT JOIN and NULLs (performance problems) (reposted)
Author tdtappe
> To make it easier to others
>
> http://groups.yahoo.com/group/firebird-support/message/64784

This is pretty cool. I didn't think of that. Thanks!

> Now of course you are aware that using any sort of left join almost
> guarantees the optimiser will decide to do the "left" table first. I
> have come across numerous cases where people have used left joins
> because they don't understand the difference, but I take it this is
> not the case here.

Thanks for pointing that out.
But I am fully aware of potential problems concerning left outer joins.

--Heiko