Join Syntax

You can embed a join in a select, update, insert, delete, or subquery. Other join restrictions and clauses may follow the join conditions.

Joins use this syntax:
start of select, update, insert, delete, or subquery 
     from {table_list | view_list} 
     where [not] 
          [table_name. | view_name.]column_name join_operator 
          [table_name. | view_name.]column_name
     [{and | or} [not]
          [table_name.|view_name.]column_name join_operator 
           [table_name.|view_name.]column_name]...
End of select, update, insert, delete, or subquery