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!!

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2