Syntax error "Missing operator" on simple update query [duplicate]

Question

I have two tables.

Table 1:

Table 2:

I want to dissolve table 2 and just add the Family column to the end of my table 1. Easy, right? So I add a family column to table 1 and

UPDATE table1 
    SET Table1.family = table2.family
FROM
table1 INNER JOIN table2 
    ON table1.ID = table2.id;

I get

Syntax Error : Missing operator.

Isn't this the syntax for these types of queries?

Declan_K · Accepted Answer · 2013-08-20 16:36:28Z

4

The MS-Access syntax for a joined update is as follows:

UPDATE table1 INNER JOIN table2 
ON table1.ID = table2.id
SET table1.family = table2.family

Declan_K

6,8162 gold badges22 silver badges31 bronze badges

answered Aug 20, 2013 at 16:30

ron tornambe

10.8k8 gold badges38 silver badges61 bronze badges

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

Comments

Hart CO · Accepted Answer · 2013-08-20 16:31:12Z

1

You have the wrong syntax, for Access use:

UPDATE table1 INNER JOIN table2 
      ON table1.ID = table2.id
SET Table1.family = table2.family;

answered Aug 20, 2013 at 16:31

Hart CO

34.9k6 gold badges52 silver badges66 bronze badges

Abhishek Jain · Accepted Answer · 2013-08-20 16:31:29Z

1

Try this:

UPDATE table1 INNER JOIN table2 ON table1.id = table2.id 
SET table1.family = table2.family;

answered Aug 20, 2013 at 16:31

Abhishek Jain

2,6271 gold badge20 silver badges12 bronze badges