[thelist] ASP.NET: UNION query not returning expected results

[Matt Warden]

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.