Developing Portable Applications > Developing Portable Applications > Achieving Transparency and Portability > DBMS Limitations with Derived Tables > Delete and Update Limitations
Was this helpful?
Delete and Update Limitations
Most DBMSs do not support derived table syntax in an UPDATE tablename FROM clause. For DELETE and UPDATE statements, subqueries may be used only in the SELECT… FROM clause inside a WHERE clause. Derived table syntax cannot be used in an UPDATE tablename FROM clause.
Last modified date: 08/22/2022