SQL Server— Update table using Inner join in SQL

We always try to keep normalization in our database and maintain table relationship for each record as possible. To maintain normalization, we always put our records in more than two tables by making relationship between them which are highly tide up mostly on primary and foreign key relationship.

Example: In an organization, based on the performance, some employees got the…