1 oj table-name
2 LEFT
2 RIGHT
2 FULL
3 OUTER JOIN
4 table-name
4 outer-join
5 ON search-condition