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.