update t_hom_onbrdbill set FALABORRELTYPEID= 1010,FALABORRELSTATUSID=1010,FPOSTYPEID=1010,FPOSSTATUSID=1020 where fid in (select fid from t_hom_onbrdbill_a where  FAFFACTIONID = 1010) and fid in (select fid from t_hom_onbrdbill_b where FISPROBATION = '1');

update t_hom_onbrdbill set FALABORRELTYPEID= 1010,FALABORRELSTATUSID=1020,FPOSTYPEID=1010,FPOSSTATUSID=1020  where fid in (select fid from t_hom_onbrdbill_a where FAFFACTIONID = 1010) and fid in (select fid from t_hom_onbrdbill_b where FISPROBATION = '0');

update t_hom_onbrdbill set FALABORRELTYPEID= 1020,FALABORRELSTATUSID=1030,FPOSTYPEID=1010,FPOSSTATUSID=1020  where fid in (select fid from t_hom_onbrdbill_a where FAFFACTIONID = 1030);