Update with inner join

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

score 4 · Accepted Answer · answered Dec 18 '12 at 15:27

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 '12 at 15:27

Mahmoud Gamal

78,257
17
139
164

Update with inner join

1 Answers1