giom/altyapi/rapor/fiyat_guncelle.sql

UPDATE TBLSTSABIT as A 
INNER JOIN sthar AS B 
on A.STOK_KODU=B.STOK_KODU
SET A.ALIS_FIAT1=round(B.NF,3),A.SATIS_FIAT3=round(B.NF+(B.NF*B.KDVORAN/100),3) 
WHERE B.FINCKEYNO='@fkod@';