UPDATE A INNER JOIN B ON A.name = B.name SET A.x = 1 WHERE A.x B.x share | improve this answer edited Sep 3 '13 at 14:13 answered Sep 2 '13 at 15:03 gus ...
stackoverflow.com