|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 1st, 2004, 10:51 AM
|
|||
|
|||
|
syntax error...using INTERSECT...EXISTS is a work around anyone know how to use it??
Quick question..
SELECT * FROM Table_1 INTERSECT SELECT * FROM Table_2 INTERSECT SELECT * FROM Table_3; Syntax error in FROM clause, and it highlights the second select.. whats wrong with this statement? does it not like the *'s? Thx
|
|
#2
July 1st, 2004, 11:10 AM
|
|||
|
|||
|
SQL server does not support intersect.
|
|
#3
July 2nd, 2004, 08:17 AM
|
|||
|
|||
|
Are you serious? What version of SQL supports interscet then .. thats really odd. Is there any way for me to accomplish the same thing as "intersect" in MSSQL? I did some research and seems like EXISTS can help me out but looks quite complicated to use.. anyone have and idea on how to use this for what i want to do..??
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > syntax error... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
