[thelist] Weird SQL problem with INTERSECT and UNION

Jason Handby jasonh at pavilion.co.uk
Wed Apr 2 01:33:13 CST 2003

> However, if I change UNION to INTERSECT, I get an
> error near INTERSECT it says.
> Any ideas? Am I doing something wrong with my
> INTERSECT query?

MS SQL doesn't support INTERSECT. Apparently you can use EXISTS or a JOIN

This page has some suggestions about how to translate from Oracle to T-SQL,
which might help you:



More information about the thelist mailing list