The following rules apply to correlated subqueries used in a ROLLBACK request:
- A FROM clause is required for a ROLLBACK request if the ROLLBACK references a table. All tables referenced in a ROLLBACK request must be defined in a FROM clause.
- If an inner query column specification references an outer FROM clause table, then the column reference must be fully qualified.
Correlated subqueries, scalar subqueries, and the EXISTS predicate are supported in the WHERE clause of a ROLLBACK request.
See and SAMPLE Clause.