caojia
7 lines
394 B
SQL
7 lines
394 B
SQL
-- 应收账单的收货时间应取订单扩展表 pickup_date，而非订单主表 order_time。
|
|
-- 只修正存在扩展表来源的快照；pickup_date 为空时保留 NULL，不回退到 order_time。
|
|
UPDATE `ar_bill_detail` d
|
|
INNER JOIN `prc_order_bill_ext` e ON e.`bill_id` = d.`prc_order_bill_id`
|
|
SET d.`receive_time` = e.`pickup_date`
|
|
WHERE NOT (d.`receive_time` <=> e.`pickup_date`);
|