Changes to DELETE and UPDATE statements; In Transact-SQL, both the DELETE and UPDATE statements are enhanced to enable data from another table to be used in the operation, without needing a subquery:

cray cray but great