SQL update Query

[zbaker]

UPDATE tblMASTERDeviceTable


SET tblMASTERDeviceTable.Manufactuer = datadump.Manufactuer
FROM datadump, tblMASTERDeviceTable
WHERE tblMASTERDeviceTable.ItemNumber = datadump.Item Number

I keep getting syntax error missing operator. Does anyone have an idea why?

[orange]

Try

UPDATE  tblMASTERDeviceTable  Inner Join datadump
ON tblMASTERDeviceTable.ItemNumber = datadump.Item Number
SET tblMASTERDeviceTable.Manufactuer = datadump.Manufactuer

[zbaker]

That fixed the syntax error but it does not do what i want it to do.
I am trying to update the manufacturer field in one table to match the other table based on the item number field. When i run the update query it asks for a manufacturer name.
Thoughts?

[John_G]

If your field name is Item Number (with a space), you need to enclose it in square brackets : [Item Number]

[orange]

We don't know the fields in your tables. I just rearranged to code in your query to remove the error.
However, if you selected the wrong fields in your query, you need to change the fields as required and use the format I posted in post #2.