UPDATE table1 T1
INNER JOIN editorial B ON B.editorial_id = T1.editorial_id
SET T1.to_design = B.`coversentto`
WHERE T1.`to_design` ='' || T1.`to_design` IS NULL
INNER JOIN editorial B ON B.editorial_id = T1.editorial_id
SET T1.to_design = B.`coversentto`
WHERE T1.`to_design` ='' || T1.`to_design` IS NULL
No comments:
Post a Comment