delete from t_bl_case where Fid in ( select n.Fid from (select Fid from t_bl_case where fstatus in (0,1,2,3,18) or YEAR(Fcreate_date)=2019) as n)
delete from t_bl_case where Fid in ( select n.Fid from (select Fid from t_bl_case where fstatus in (0,1,2,3,18) or YEAR(Fcreate_date)=2019) as n)
转载于:https://www.cnblogs.com/shanshanyuxuan/p/10613528.html