Update a attribute into one table to another table

query =  UPDATE table2
INNER JOIN table1 ON table2.attribute = table1.attribute
SET table1.attribute =  ‘value for update’
WHERE table2.attribute  = ‘value for check’;

Advertisements