bİlnex v3 verİtabani İÇİn geÇerlİdİr.
-------------------------------------------------------------------------------
update stok
set
alisf1=isnull((select top 1 tlfiyat from stok_har where stok_har.kodu=stok.kodu and stok_har.gdepo<>'' and stok_har.tlfiyat>0 order by tarih desc),0)