[thelist] Weird SQL problem with INTERSECT and UNION

[Jeff Howden]

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/    |
---------------------------------------------------------------------