1 table-reference 1.1! INNER 1.1? 1.1.0 LEFT 1.1.0 RIGHT 1.1.0 FULL 1.1.1! OUTER 1.1.2 JOIN table-reference ON join-condition 1 table-reference CROSS JOIN table-reference 1 ( joined-table )
1 table-reference 1.1! INNER 1.1? 1.1.0 LEFT 1.1.0 RIGHT 1.1.0 FULL 1.1.1! OUTER 1.1.2 JOIN table-reference ON join-condition 1 table-reference CROSS JOIN table-reference 1 ( joined-table )