Write a sql query using joins in sql server

Retriving the unmatched records from left table in sql server?

Your Answer

SELECT t1.* FROM tb1 t1 LEFT JOIN tb2 t2 ON t1.key=t2.key WHERE t2.key is NULL

0
Forum   Other Related Discussions
Sql Server

Didn't get the answer.
Contact people of Talent-Sql Server directly by clicking here