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 <column_name> from <table_name1>
intersect
select <column_name> from <table_name2>

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 <column_name> from <table_name1>
intersect
select <column_name> from <table_name2>
the error is:Incorrect syntax near the keyword 'intersect'.

[QUOTE=vishnukumar;18131]hi,

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

I tried the following syntax, but it is not working

select <column_name> from <table_name1>
intersect
select <column_name> from <table_name2>

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

these two r showing syntax error

Please, share ur knowledge about these

Thanks in advance,
Vishnu[/QUOTE]


Try this query in SQL server 2005

select <column_name> from <table_name1> intersection
select <column_name> from <table_name2>