Left Join

Left Join

Left Join return all rows from the right table, and the matched rows from the left table.

The RIGHT JOIN keyword returns all rows from the right table (table2), with the matching rows in the left table (table1). The result is NULL in the left side when there is no match.

	
SQL RIGHT JOIN Syntax
SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name=table2.column_name;

or

	
SELECT column_name(s)
FROM table1
RIGHT OUTER JOIN table2
ON table1.column_name=table2.column_name;

Note: In some databases Left JOIN is called Left OUTER JOIN.

Employee table

Payment table

After apply right join on these two table, result show like below;

	
SELECT Employee.emp_id, Payment.Name
FROM Employee
RIGHT JOIN Payment
ON Employee.emp_id=Payment.Payment_id
ORDER BY Employee.emp_id;

In above syntax we select 2 columns, emp_id and name from table Employee and table Payment. And retrieving all rows where the employee identification number is the same in both the Employee and Payment tables.