Update Table Using Join In SQL Server

Today We will learn about Update  Table Using Join In SQL Server


We have two table one is Bank Table  and another is SwitCode Table

Bank Table: Below is the following Script for creating table

 

 

 

Fig: Bank table with data

SwitCode Table:  Below is the following Script for creating table

 

 

 

Fig: SwitCode table with data

Condition:  SwitCode of bank table have to update form SwitCode table using Bank_id.

Below is the following query

After executing above query then output

 

 

Fig:Bank Table

Leave a Reply

Your email address will not be published. Required fields are marked *