Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to update records using update statements with join in sql server?
Ask Question
Revati S Misra
Revati S Misra

Student

Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Message

1 Answers

Aryan Kumar
Aryan Kumar 12 Jul 2023
Report Abuse

Updating records using update statements with join in SQL Server

You can update records using update statements with join in SQL Server by using the UPDATE statement with the JOIN clause. The JOIN clause allows you to join two tables together and update the records in one table based on the records in the other table.

The syntax for updating records using update statements with join in SQL Server is as follows:

SQL

UPDATE table_name
SET column1 = value1,
    column2 = value2,
    ...
FROM table1
JOIN table2
ON table1.column1 = table2.column1;

The table_name is the name of the table that you want to update. The column1, column2, etc. are the columns that you want to update. The value1, value2, etc. are the new values for the columns. The table1 and table2 are the names of the tables that you want to join. The column1 and column2 are the columns that you want to join on.

For example, the following code will update the CustomerName column in the Customers table to John Smith for all customers where the CustomerID is 100:

SQL

UPDATE Customers
SET CustomerName = 'John Smith'
FROM Customers
JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
WHERE Customers.CustomerID = 100;

This code will first join the Customers and Orders tables on the CustomerID column. Then, it will update the CustomerName column in the Customers table to John Smith for all rows where the CustomerID is 100.

MindStick Training