giom/altyapi/sql/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),A.SATICI_KODU=B.HEDEF 
WHERE B.FINCKEYNO='@fkod@';