SQL: Update using correlated subquery

An example of updating the values in one table using data from another table. To do this, you need a subquery that preforms a lookup for each row in the table being updated.

[nowie]

11 years later and still what a masterpiece, first vid that's so well explained and so basic. Thanks a lot

[anpowersoftpowersoft]

Thank you very much for the excellent explanation

[thomasre]

I liked Visible Man (reflects photons) the most. ;)

[robinrai]

how to update statement with two where condition