Skip to main content

update from another table

UPDATE 
  table1 T1
, table2 T2
set 
T1.[Description2]=T2.[Caption]

where 
T1.[ProductCode] = T2.[Shop Products Plu ID];