delete y from dbo.XZXK_BANJIE b ,YJDC_YELLOWRED_CONTENT y , dbo.XZXK_SHOULI s
where b.shoulioid=s.shoulioid and y.caseid=s.caseid and b.BJSJ > y.SEND_YELLOWRED_DATE
delete y from dbo.XZXK_BANJIE b ,YJDC_YELLOWRED_CONTENT y , dbo.XZXK_SHOULI s
where b.shoulioid=s.shoulioid and y.caseid=s.caseid and b.BJSJ > y.SEND_YELLOWRED_DATE