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

Dup post:

http://forums.databasejournal.com/sh...ad.php?t=50401

You still use SQL Server 6.5?

MS doesn't even support SQL 7.0

You have to upgrade asap.