MySQL – Right Join
By using a Right Join, two or more tables are joined, and only those rows from the other table that satisfy the join condition are returned. When there are no matches in the left-hand table, a NULL value is returned. This method is similar to the Left Join except that the results of the join tables are reversed. Alternatively, it is called a Right Outer Join. As a result, Outer is an optional clause for Right Joins.
SELECT column_list FROM Table1 RIGHT [OUTER] JOIN Table2 ON join_condition;
This join begins by selecting the columns from the right-hand table and matches each record in this table against the records in the left-hand table. Both records must fulfill the given join condition in order for a new row set to be returned as output. If the right-side table does not contain any rows matching the left table, it combines those rows with Null values. Right Join returns all data from the right-side table, regardless of whether it matches the rows from the left table.
SELECT employees.emp_no ,employees.first_name FROM employees RIGHT JOIN dept_emp ON dept_emp.emp_no = employees.emp_no;