Mysql 3表关联并更新字段

mysql 3表关联更新某个字段.

查询并更新 A客户的某个时间段的order下的item，并进行操作。item.price=item.quantity*item.unity_price

 

UPDATE sale_planorderitem a 
INNER JOIN 
(SELECT b.id FROM sale_planorder b, customer_customer c WHERE c.short_name='客户名称' AND b.customer_id=c.id AND b.add_time>='2019-08-01 00:00:00' AND b.add_time<='2019-10-01 00:00:00') as t
ON a.order_id=t.id SET a.total_price=a.unit_price*a.quantity