实例
UPDATE product_order po
INNER JOIN product_customer pc ON pc.product_id = po.pro_id
INNER JOIN customer c ON c.id = pc.customer_id
SET po.product_time = DATE_SUB(po.delivery_date,INTERVAL 1 DAY)
WHERE po.product_time is NULL
AND c.product_time_type = 1
INNER JOIN product_customer pc ON pc.product_id = po.pro_id
INNER JOIN customer c ON c.id = pc.customer_id
SET po.product_time = DATE_SUB(po.delivery_date,INTERVAL 1 DAY)
WHERE po.product_time is NULL
AND c.product_time_type = 1