SQL update subquery in where clause

How To Update a Table Neat Way Using Subquery

Here is a SQL subquery example to update a Table. It’s the neat way when you have data to fetch from two tables.