SELECT UPDATE

UPDATE 테이블1 a

INNER JOIN 테이블2 b ON a.컬럼1= b.컬럼1

SET a.컬럼2=b.컬럼2

출처: http://stackoverflow.com/questions/871905/use-select-inside-an-update-query