Thread: intersection in SQL server 2000

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

you can Use Inner Join for the operation of intersection

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
the error is:Incorrect syntax near the keyword 'intersect'.

Originally Posted by vishnukumar

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

Try this query in SQL server 2005

select from intersection
select from