update ...from 语法是早就知道的,今天把delete琢磨出来了 记录以备忘
delete a from t_sms_send a, t_sms_diaocha_send b
where b.dcid=10 and a.dxnrid=b.dxnrid and a.fssj=b.fssj
update t_sms_send set dxnrid='1' from t_sms_send a,t_sms_diaocha_send b
where b.dcid=10 and a.dxnrid=b.dxnrid and a.fssj=b.fssj