how to compare two different tables column in sql server

Question

i want to compare two different columns from two different tables in sqlserver ex. tbl_t1 col1 tbl_t2 col1

Upendra Pratap Shahi · Answer

If you are working in SQL 2008,2012+ then use merge command in which you have to give source and destination table. There is two question- 1- Is both table in same database? 2-Is both from other database? Look this link- http://sqlfiddle.com/#!3/6b4b0/3 https://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/

Nanhe Siddique · Answer

use this code SELECT b.Product, b.Qty, b.Price, Result = CASE WHEN a.product IS NULL THEN 'New' ELSE 'Updated: ' + STUFF( CASE WHEN a.Qty != b.Qty THEN ',Qty' ELSE '' END + CASE WHEN a.Price != b.Price THEN ',Price' ELSE '' END, 1, 1, '') END FROM TableB b LEFT JOIN TableA a ON a.Product = b.Product WHERE a.Product IS NULL OR a.Qty != b.Qty OR a.Price != b.Price; it may help you

Prasham Sabadra · Answer

Hi Raj, I didnt tried but please have a look at following links: http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx http://stackoverflow.com/questions/2077807/sql-query-to-return-differences-between-two-tables

how to compare two different tables column in sql server

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)