UPDATE multiple tables in MySQL using LEFT JOIN - Stack Overflow

UPDATE t1 LEFT JOIN t2 ON t2.id = t1.id SET t1.col1 = newvalue WHERE t2.id IS NULL. Note that for a SELECT it would be more efficient to use NOT ...

www.google.com.tw