MINUS or a Nested Select

Hi

How comes this works:

SELECT COUNT(IndexID) FROM [Table1]
MINUS
SELECT COUNT(IndexID) FROM [Table2];

But this doesnt:

SELECT COUNT(IndexID) FROM [Table1]
WHERE IndexID NOT IN (SELECT IndexID FROM [Table2]);

I would have thought that they do the same thing?? Many thanks

Thiko! Received on Wed Feb 02 2005 - 09:17:56 CST