SQL update with correlated subquery - Bang Bang Technologies

SQL update with correlated subquery A correlated subquery is a SELECT statement nested inside another T-SQL statement, ... When you use a correlated subquery in an UPDATE statement, the correlation name refers to the rows you are interested in ...

data.bangtech.com