[thelist] Weird SQL problem with INTERSECT and UNION
Jeff Howden
jeff at jeffhowden.com
Wed Apr 2 00:42:20 CST 2003
ted,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: ted serbinski
>
> > However, if I change UNION to INTERSECT, I get an
> > error near INTERSECT it says.
>
> Think I figured out my own question. Seems like MS SQL
> does not support INTERSECT, which is quite odd. [...]
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
it does support intersect, but as a function not as an operator. do a
search for intersect in your "sql books online" which is an installable
reference manual for sql server.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> [...] Is there any work arounds for this or hacks to
> emulate it?
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
again, according to the installable docs, exists and not exists are for
determining intersection and difference.
good luck,
.jeff
http://evolt.org/
NOTICE: members.evolt.org web and email address are changing!
---------------------------------------------------------------------
| OLD: | NEW: |
| jeff at members.evolt.org | evolt at jeffhowden.com |
| http://members.evolt.org/jeff/ | http://evolt.jeffhowden.com/ |
---------------------------------------------------------------------
More information about the thelist
mailing list