How to UPDATE statement with JOIN in SQL Server?

Question

How to UPDATE statement with JOIN in SQL Server?

I want to update this table in SQL Server with data from its 'parent' table, see below:

Table: sale*

id (int)
udid (int)
assid (int)

*Table: ud



id  (int)

assid  (int)

sale.assid contains the correct value to update ud.assid.

What query will do this? I'm thinking of a join but I'm not sure if it's possible.

sql sql-server

4 years ago by rahul07

2 Answers

Login / Signup to Answer the Question.

Login Signup

**Sonali7** · Answer 1 · 2021-05-01T11:07:29

The following code can be implemented in SQL Server to UPDATE statement with JOIN:

update u

set u.assid = s.assid

from ud u

    inner join sale s on

        u.id = s.udid

**espadacoder11** · Answer 2 · 2021-05-03T13:59:11

A standard SQL approach would be



UPDATE ud

SET assid = (SELECT assid FROM sale s WHERE ud.id=s.id)

On SQL Server you can use a join



UPDATE ud

SET assid = s.assid

FROM ud u

JOIN sale s ON u.id=s.id

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

How to UPDATE statement with JOIN in SQL Server?

2 Answers

Login / Signup to Answer the Question.