SQL: Cannot UPDATE or DELETE from subquery (Error 2151)

This error is generated when the target for a UPDATE - SQL Command or DELETE - SQL Command is a sub-query.