Comparing Databases

Hey all,

Trying to compare unique fields from two databases.

Basically what i'm trying to do is get all of the id's out of one field that don't exsist in the 2nd database.

so I have this query


Code:


select Distinct Id
from table1
where ID!= (select Distinct ID from table2)



I'm getting this error

Server: Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.


Now I don't understand why because then I query
select id from tables 2

I only get 1 value for each row.

Now you should know, the two columns in either table are different, in one of them the first value is "1" in the other the first value is "00000001" although I don't think that should effect anything.

Any idea's?

Thanks