hi,

What is the syntax for INTERSECTION Function in SQL server 2000?

I tried the following syntax, but it is not working

select from
intersect
select from

intersect({[1],[2]},{[1]})

these two r showing syntax error

Please, share ur knowledge about these

Thanks in advance,
Vishnu