[sql] update & join

UPDATE tablea a
INNER JOIN tableb b
ON a.키워드=b.키워드
SET a.검색량=b.검색량
WHERE b.검색량 > 100

https://www.next-t.co.kr/seo/sql/%EC%97%85%EB%8D%B0%EC%9D%B4%ED%8A%B8update-%EC%8B%9C-%ED%85%8C%EC%9D%B4%EB%B8%94-%EC%A1%B0%EC%9D%B8table-join-%EA%B5%AC%EB%AC%B8/