Compare data from two databases

[perelo]

I have got 2 databases on the same server, I want to compare data from one column in each database.
The statement this far looks like this:

SELECT * from main
WHERE record_id NOT like ......and this is where`I´m lost, how do I tell the script to look in the other database?

I´ve tried this without any luck:

SELECT * from main
WHERE record_id NOT like [CMGVoice] users.dbo cmgrecid


Sincerly, Per

 

[SQLDenis]

SELECT * from main
WHERE record_id NOT in (select record_id from dbname.ObjectOwner.Object )

dbname.ObjectOwner.Object example
(Pubs.dbo.publishers)

http://sqlservercode.blogspot.com/