On 9/27/07, Phil Turmel <pturmel-webdev at turmel.org> wrote: > Hi Joel, Rudy: > > Sorry for jumping in late, but why have a union at all? At least in Oracle, in many(most?) cases, the union-all will be significantly faster than the left join. Interestingly, though, our friend Rudy has an article on 'Ask the Oracle Expert' where he ponders why anyone would ever want to use the non-left-join syntax to perform the left join: "As mentioned, it's pretty hard to imagine why you wouldn't want to use the LEFT OUTER JOIN." -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.