UPDATE taxi_ad_vhc vhc
SET ad_del_flag = (SELECT 2
FROM ut_ad_vhc_resend resend
WHERE ad_id = vhc.ad_id
AND vid = vhc.vid
AND resend.ad_flag = 2)
WHERE EXISTS (SELECT 1
FROM ut_ad_vhc_resend resend
WHERE resend.vid = vhc.vid
AND resend.ad_id = vhc.ad_id
AND resend.ad_flag = 2)
根据表ut_ad_vhc_resend(resend)级联更新表taxi_ad_vhc(vhc),
条件:
1.vhc.ad_id = resend.ad_id
2.vhc.vid = resend.vid
要更新的字段: ad_del_flag (vhc)
当resend.ad_flag = 2时, vhc. ad_del_flag = 2