Select plaka,aracid,(select top 1 aracid from oto_arackarti oa where oa.plaka=ok.plaka) from oto_arackabul ok
update oto_arackabul set aracid=(select top 1 aracid from oto_arackarti oa where oa.plaka=oto_arackabul.plaka)