sql query

Vedant

11y1.1k

i have two data table with same column name.i want to compare two column value of one data table to 2 column of another data table.and get which is not exist into second data table.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma11y ago
https://www.mssqltips.com/sqlservertip/2779/ways-to-compare-and-find-differences-for-sql-server-tables-and-data/
+1

Jitendra Kumar11y ago

See limk :-

https://technet.microsoft.com/en-us/library/bb522522(v=sql.105).aspx

-- MERGE statement with the join conditions specified correctly.

 USE tempdb; GO BEGIN TRAN;

 MERGE Target AS T USING Source AS S ON (T.EmployeeID = S.EmployeeID)

WHEN NOT MATCHED BY TARGET AND S.EmployeeName LIKE 'S%'

 THEN INSERT(EmployeeID, EmployeeName) VALUES(S.EmployeeID, S.EmployeeName)

 WHEN MATCHED      THEN UPDATE SET T.EmployeeName = S.EmployeeName

WHEN NOT MATCHED BY SOURCE AND T.EmployeeName LIKE 'S%'

THEN DELETE  OUTPUT $action, inserted.*, deleted.*;

ROLLBACK TRAN;

Ravi Kumar11y ago
select *from table1 where tb1column1 not in (select tb2column1 from table2)
+1
Jignesh Trivedi11y ago
hi,
Please refer below link it might help you.
http://www.fourthbottle.com/2014/07/how-to-get-difference-between-two.html
http://www.c-sharpcorner.com/UploadFile/akkiraju/find-difference-of-data-between-two-data-sources/
+1
Deepak Solanki11y ago
Hi,

You can use FULL JOIN to compare a common column in two different table.
Try this:
SELECT * FROM TABLE1 FULL JOIN TABLE2 ON TABLE1.COMMONCOLUMN = TABLE2.COMMONCOLUMN WHERE TABLE1.COMMONCOLUMN IS NULL OR TABLE2.COMMONCOLUMN IS NULL

Regards,
Deepak
+1