SQL RIGHT JOIN Keyword

The RIGHT JOIN keyword returns all records from the right table (table2), and the matching records from the left table (table1). The result is 0 records from the left side, if there is no match.

Example

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

Note:The RIGHT JOIN is also called RIGHT OUTER JOIN .

Demo Employee table

This employee table is used for examples:

Demo Products table

This product table is used in examples:

SQL RIGHT JOIN Example

The following SQL statement will select all employee, and any orders they might have:

Example

 SELECT  products.Product_id, employee.Country, employee.Employee_name
 FROM  products
 Right JOIN employee
 ON  products.Employee_id = employee.Employee_id
 ORDER BY products.Product_id;

You can click on above box to edit the code and run again.

Output

Note: The RIGHT JOIN keyword returns all records from the right table (employee), even if there are no matches in the left table (Orders).