mileage_cate테이블에서 값을 가져와 mileage테이블에 있는값 더하기

AddMileage.sql

UPDATE
	tb_person p
SET
	p.person_total_mileage =
	(SELECT 
		SUM(mct.mileage_cate_price - m.mileage_use_price)
	FROM
		tb_mileage m
	JOIN
		tb_mileage_cate mct
	ON m.mileage_cate_cd = mct.mileage_cate_cd
	WHERE
		m.person_id = 'person3'
	)
WHERE
	p.person_id ='person3'