delete from t_tran_datasend a,
where exists(select 1 from t_tran_ctrl b where a.vc_srchopid=b.vc_srcshopid and a.vc_destshopid=b.vc_destshopid and a.vc_tranno=b.vc_tranno and b.dt_execdate<delay_date and b.nu_status<>0);
where exists(select 1 from t_tran_ctrl b where a.vc_srchopid=b.vc_srcshopid and a.vc_destshopid=b.vc_destshopid and a.vc_tranno=b.vc_tranno and b.dt_execdate<delay_date and b.nu_status<>0);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货