Skip to main content

How to Compare Two Columns from Two Different Tables [SQL Server?]

This below query is help us to compare two columns from two different tables and also for two different database tables.

Stayed Informed - End To End SQL Server with Q/A

-- HOW TO COMPARE TWO COLUMNS FROM TWO DIFFERENT TABLES IN SQL?
SELECT * FROM  [DBO].TRANSLATION_1 AS T1
  WHERE NOT EXISTS (
 SELECT * FROM [DBO].TRANSLATION_2  AS T2 
 WHERE T1.Field_Name = T2.Field_Name and T1.Entity_Name =T2.Entity_Name
)



-- HOW TO COMPARE TWO COLUMNS FROM TWO DIFFERENT DATABASE TABLES IN SQL?
SELECT * FROM  [DB1].[DBO].TRANSLATION_1 AS T1
   WHERE NOT EXISTS (
  SELECT * FROM [DB1].[DBO].TRANSLATION_2  AS T2 
 WHERE T1.Field_Name = T2.Field_Name and T1.Entity_Name =T2.Entity_Name
)

I hope you are enjoying with this post! Please share with you friends. Thank you!!
Labels: