-
EXCEPT or MINUS operators in MSSQL 6.5
Hi,
As I understand, MSSQL 6.5 does not support EXCEPT, MINUS & INTERSECT operators. Can anyone provide me alternate syntax to achieve the replacement for these operators in the 'SAME' version? I need it from data migration perspective where it needs to execute queries only on version 6.5
Thanks ain advance.
Regards,
Avadhoot
-
You can create primary/unique key on each table and create queries using EXISTS or NOT EXISTS sub queries.
INTERSECT is a regular join.
-
Thanks for this solution.. it worked
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|