To perform a subquery as an noncorrelated subquery and not as a correlated subquery, observe the following guidelines.
- For each main and subquery you code, ensure that its scope is local by specifying a FROM clause that includes all the tables it references.
- Instead of specifying join operations in the main queries of DELETE and UPDATE statements, restrict them to subqueries.