here’s the correct syntax of UPDATE
with join in MySQL
UPDATE table1 a
INNER JOIN table2 b
ON a.ID = b.ID
SET a.value = b.value
- SQLFiddle Demo
here’s the correct syntax of UPDATE
with join in MySQL
UPDATE table1 a
INNER JOIN table2 b
ON a.ID = b.ID
SET a.value = b.value