--update t_vc_smartaccountingreport set FSTATUS  =2 where fid in (SELECT fid FROM t_vc_smartaccountingreport where FSMARTACCOUNTINGID = (SELECT fid FROM t_vc_smartaccountingschema where FNUMBER ='方案编码')and FSTATUS !=2)