You can embed a join in a select, update, insert, delete, or subquery. Other join restrictions and clauses may follow the join conditions.
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