SQL RIGHT JOIN

The RIGHT JOIN returns all rows from the right table (table2), and only the matched rows from the left table (table1). If there is no match in the left table, the result for the columns from the left table will be NULL.

and

keyword is optional.

column_name(s)

table1

table2 ON table1.column_name = table2.column_name

Below is a selection from the "Orders" table:

10308

10309 37

10310 77

And a selection from the "Employees" table:

EmpID1.pic

EmpID2.pic

EmpID3.pic