Update with inner join [duplicate]

Question

Possible Duplicate:
Update a table using JOIN in SQL Server?

I am stuck on a very simple query, an update with a join, I want to put the value of the field RECORDTYPE in the RECORDTYPE field = to the value of TEMPLATETABLE.RECORDTYPE

I tried with this but I get continuous syntax errors, which is the problem?

update MAINTABLE MT
set MT.MYTYPE =  TT.RECORDTYPE 
inner join TEMPLATETABLE TT on TT.ID_RECORD_TEMPLATE = MT.ID_RECORD_TEMPLATE

Mahmoud Gamal · Accepted Answer · 2012-12-18 15:27:32Z

4

You are missing the FROM clause. Try this instead:

UPDATE MT
SET MT.MYTYPE =  TT.RECORDTYPE 
FROM MAINTABLE MT
INNER JOIN TEMPLATETABLE TT 
        ON TT.ID_RECORD_TEMPLATE = MT.ID_RECORD_TEMPLATE

answered Dec 18, 2012 at 15:27

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update with inner join [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related