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

Matt Warden mwarden at gmail.com
Thu Sep 27 21:11:36 CDT 2007

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

Matt Warden
Cincinnati, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list