IMG-LOGO

How to update table with join another table in TSQL?

andy - 26 Feb, 2021 2872 Views 0 Comment

In this article, we going to learn how to update a table with join another table in SQL Server. Let says we have two products table as below.

We are going to update the Product table based on the data we have from the Main Product Table. Both tables are joined by Id.

Here is the full TSQL Query to update a table with join another table in SQL Server.


UPDATE P
SET P.Name = MP.Name,
	P.Price = MP.Price,
	P.SKU = MP.SKU
FROM Products P
INNER JOIN MainProducts MP
ON P.Id = MP.Id

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Articles

How to restore database using SQL query in TSQL?

If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

How to get all table sizes in TSQL?

To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...