Re: Conjunction junction
Date: Mon, 1 Nov 2004 16:37:19 -0500
Message-ID: <CYadnalYVqQIMRvcRVn-qw_at_comcast.com>
"Tony Andrews" <andrewst_at_onetel.com> wrote in message news:1099340390.751573.125250_at_c13g2000cwb.googlegroups.com...
> Yes, you would need to use a different name because that is not what
> XOR means. What you are looking for is a quota ("TOP 1" in some SQL
> flavours), not a logical operator at all.
Agreed. I was trying to say the same thing earlier. A google search on "XOR Boolean" confirms our view.
In some cases, where a query wanted to use some construct like "TOP 1" in order to save time, I've been able to use WHERE EXISTS (subquery) to get almost the same speed up. It depends on what info you are really looking for.
And of course, there's WHERE NOT EXISTS (subquery), a construct that should be required learning for SQL jockeys. Received on Mon Nov 01 2004 - 22:37:19 CET