update from another table

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

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

Revision #1
Created 10 May 2024 14:26:05 by Nan Li
Updated 10 May 2024 14:26:42 by Nan Li