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
