How to take Diffrence of sets?

[sqltimmy]

I have a query with one column and 937 rows.
I have another query with the same one column and 595 rows.
I want to query the difference of these queries, but I am having a heck of a time finding the syntax to do it! I'm using SQL Server 2000 and it's not liking the DIFFERENCE function...

Example SQL:

SELECT ID
FROM TABLE1

[insert magic function here!]

SELECT ID
FROM TABLE2

 

[sunila7]

Hi,

I think this should give u the results u want

SELECT ID
FROM TABLE1 where ID Not IN(
SELECT ID
FROM TABLE2)

Sunil

 

[tlbroadbent]

Here are two other options. They should prove more efficient than a NOT IN query.

Not Exists:

Select ID
From table1
Where not exists
(Select * From table2 Where ID=table1.ID)

Left Join:

Select ID
From table1
Left Join Table2
On table1.ID=table2.ID
Where table2.ID Is Null Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.