OUTER JOIN

Database Dictionary -> OUTER JOIN

OUTER JOIN

The OUTER JOIN clause returns all rows from at one or more of the tables specified in the FROM clause. OUTER JOIN can be a LEFT OUTER JOIN, a RIGHT OUTER JOIN, or FULL OUTER JOIN

SQL Tutorial