select A.MUSNO, A.MUSADI,S.StokKodu ,ST.StokAdi ,S.Tutar,S.IslemTuru
FROM AMUSTERI A CROSS APPLY 
(SELECT top 10 CariNo, IslemTuru ,StokKodu , ROUND (SUM(SonTutar),2) Tutar FROM STOKHAR S2 WHERE S2.CariNo=A.MUSNO AND FisTuru ='F' GROUP BY CariNo,StokKodu,IslemTuru ) S
left join STOKKARTI ST ON ST.Kodu=S.StokKodu 
ORDER BY 1  ,5  DESC