Check for a value from table 1 in table 2 on different servers -

i struggling how , examples have found seem overly complicated need accomplish.

i have 2 tables in separate databases on separate servers. need see if server1,db1, table1, column2 contains values not in server2,db2, table1, column2?

i not sure start?

with below, here tried , error:

the multi-part identifier "net_test.dbo.details" not bound. 

query:

declare @rcasenum nvarchar(30); declare @currentyear datetime; declare @eventnumber nvarchar(30); declare @casenum nvarchar(30); set @eventnumber = [net_test].[dbo].[details] set @casenum = [sqltest10\sqltest10].[case_test].[dbo].incident set @currentyear = year(getdate()); set @rcasenum =  @currentyear + @eventnumber select @eventnumber except select @casenum 

except or not exists best choices. wrote bit them on answer.

an example of except.

select column2 db1.table1 except select column2 db2.table1 

in case, beware of using not in.