Combines records from two tables. Returns all records from the table on the right side of the join, even if there are no matching records in the table on the left side of the join. The join is specified in the FROM clause. The syntax is:
FROM leftTable RIGHT JOIN rightTable ON leftTable.field1 comparison-operator rightTable.field2