Subject | Re: LEFT JOIN and NULLs (performance problems) (reposted) |
---|---|
Author | tdtappe |
Post date | 2005-08-15T12:25:12Z |
> To make it easier to othersThis is pretty cool. I didn't think of that. Thanks!
>
> http://groups.yahoo.com/group/firebird-support/message/64784
> Now of course you are aware that using any sort of left join almostThanks for pointing that out.
> 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.
But I am fully aware of potential problems concerning left outer joins.
--Heiko