更新语句:
UPDATE vr_work_order t1,vr_dispatch_order t2
SET t1.WORK_STATUS = "LEAVE_FACTORY"
WHERE
t1.DISPATCH_NO = t2.VRDO_NO
AND t2.VRDO_STATUS IN ( "APPOINTMENT" )
AND "2021-04-30 23:59:59" >= t2.CREATE_TIME
删除语句:
DELETE t1
FROM
vr_dispatch_card_driver t1
LEFT JOIN vr_dispatch_order t2 ON t1.VRDO_NO = t2.VRDO_NO
WHERE
t2.VRDO_STATUS IN ( "APPOINTMENT" )
AND "2021-04-30 23:59:59" >= t2.CREATE_TIME