--ZAMANAŞIMI OLABİLİR
update STOKHAR set STOKHAR.StokTipi = STOKKARTI.StokTipi from STOKHAR , STOKKARTI where STOKHAR.StokTipi not in (select distinct StokTipi from STOKKARTI) and STOKHAR.StokKodu = STOKKARTI.Kodu 