update b set b.FC_ID = f.ID from bargeh b inner join Finance_Cycle f on left(b.Tarikh,4) = f.Code where b.FC_ID < 0 update b set b.FC_ID = f.ID from DaryaftPardakht b inner join Finance_Cycle f on left(b.Tarikh,4) = f.Code where b.FC_ID < 0