SQL: Update Values from Another Table using UPDATE Statement with Subquery in WHERE clause

Learn how to update the data in Column of one table from another table.
In this example, we update JobTitle in the Employee table by selecting JobTitle from the EmpSalary table for matching EmpID values of two tables using Subquery in WHERE clause.

#Shorts#MsSQL#SQLUpdate

[pravingaddam]

How to write for update if we need to update multiple columns using same query