mysql语句update、delete关联表处理

更新语句：

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