SELECT tblYeniTedarik.SiparisID, tblYeniTedarik.StokId, tblUrunler.StokAdi, Sum(tblYeniTedarik.SevkAdet) AS ToplaSevkAdet
FROM tblYeniTedarik INNER JOIN tblUrunler ON tblYeniTedarik.StokId = tblUrunler.StokId
GROUP BY tblYeniTedarik.SiparisID, tblYeniTedarik.StokId, tblUrunler.StokAdi;