The RIGHT JOIN keyword retrieves all data from the right table (table2) and the corresponding data from the left table (table1). If there is no match, the left side returns 0 records.

When using the RIGHT JOIN keyword, all records from the right table (Employees) are returned even if there are no matches in the left table (Orders).

• The join is done by the JOIN operator.
• In the FROM clause, the name of the first table ( product ) is followed by a JOIN keyword then by the name of the second table ( category ).
• This is then followed by the keyword ON and by the condition for joining the rows from the different tables.