INNER JOIN: SELECT ... FROM table1 [INNER] JOIN table2 ON conditional_expression ... To avoid redundancy and keep the phrasing shorter, INNER JOIN conditions can be declared with a USING expression. JOIN: SELECT ... FROM table1 LEFT OUTER JOIN table2 ON conditional_expression ... To avoid redundancy and keep the phrasing shorter, OUTER JOIN conditions can be declared with a USING expression.