SELECT a.ID, a.Emri, SUM(db.Sasia1)as SasiaBler, SUM(d.Sasia)as SasiaShitur,
SasiaBler - SasiaShitur as Stoku
FROM dbo.Artikujt as a INNER JOIN
dbo.FaturaBDetalet as db ON a.ID = db.ArtikullID INNER JOIN
dbo.FaturatDetalet as d ON a.ID = d.ArtikulliID
group Go to the complete details ...