Microsoft Access Update Query Examples, SQL Syntax

Reference:
http://www.fmsinc.com/MicrosoftAccess/query/snytax/update-query.html

update Raw_data
inner join dbo_BOMMD b on Raw_data.Part_no = b.MD003
set Part_no = b.MD001
where Assy > 0