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
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