Okay this is my first attempt at using the INTERSECT operator and I keep
getting Incorrect syntax near the keyword 'INTERSECT'

Even something as simple as

select '5'

INTERSECT

select '5'

gives the error. Any tips on what's the proper usage? I've scoured the web
and help files.





Jeremiah Christensen




MS Sql Server LazyDBA home page