There are two classes of JOINS: Oracle Syntax and ANSI SQL:1999 Standard. Match the corresponding expressions. See Page 15 on the Oracle SQL Reference Guide.