Category: SQL Server
view more software Tips and Tricks
Updated: 12/15/2015 06:12 AM
Author: Shiju Mathews
This can be found by left or right join as per the requirement.
The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.