SELECT tbCustomer.fKodeSales,
           tbBarang.fKategori,
           SUM(tbKanvasJualM.fTotal) AS SumTotal,
           SUM(tbBarang.fIsi) AS SumIsi,
           SUM(tbKanvasJualDet.fQty) AS SumQty
      FROM (           tbCustomer
             INNER JOIN tbKanvasJualM ON tbCustomer.fKodeCust =tbKanvasJualM.fKodeCust
           )
INNER JOIN (           tbBarang
            INNER JOIN tbKanvasJualDet ON tbBarang.fKodeBrg = tbKanvasJualDet.fKodeBrg)
        ON tbKanvasJualM.fNoKanvasJual = tbKanvasJualDet.fNoKanvasJual
  GROUP BY tbCustomer.fKodeSales, tbBarang.fKategori;

fKodeSales  |fKategori  |SumTotal   |SumIsi |SumQty

ACONG       |DEPAN      |$170,000.00    |500    |10

ACONG       |HLG        |$1,500,000.00  |2  |3

ACONG       |LAIN2      |$252,400.00    |4200   |220

ALIANGPB    |DEPAN      |$467,000.00    |1100   |110

ALIANGPB    |HLG        |$10,160,000.00 |1  |20

ALIANGPB    |LAIN2      |$10,160,000.00 |1000   |100

SELECT tbCustomer.fKodeSales,
           tbBarang.fKategori,
           SUM(tbKanvasJualM.fTotal) AS SumTotal,
           SUM(tbBarang.fIsi) AS SumIsi,
           SUM(tbKanvasJualDet.fQty) AS SumQty ,
           SUM(tbReturJDet.fQty)
      FROM (           tbCustomer
            INNER JOIN tbKanvasJualM ON tbCustomer.fKodeCust = tbKanvasJualM.fKodeCust)
INNER JOIN (           tbBarang
            INNER JOIN tbKanvasJualDet ON tbBarang.fKodeBrg = tbKanvasJualDet.fKodeBrg)
        ON tbKanvasJualM.fNoKanvasJual = tbKanvasJualDet.fNoKanvasJual
 LEFT JOIN tbReturJDet
        ON tbReturJDet.fKodeBrg=tbKanvasJualDet.fKodeBrg
  GROUP BY tbCustomer.fKodeSales, tbBarang.fKategori

SELECT
tbCustomer.fKodeSales,
tbBarang.fKategori,
Sum(tbKanvasJualM.fTotal) AS SumTotal,
Sum(tbBarang.fIsi) AS SumIsi,
Sum(tbKanvasJualDet.fQty) AS SumQty,
SUM(tbReturJDet.fQty)
FROM
tbCustomer
INNER JOIN tbKanvasJualM ON tbCustomer.fKodeCust = tbKanvasJualM.fKodeCust
INNER JOIN tbKanvasJualDet ON tbKanvasJualM.fNoKanvasJual = tbKanvasJualDet.fNoKanvasJual
INNER JOIN tbBarang  ON tbBarang.fKodeBrg = tbKanvasJualDet.fKodeBrg
LEFT JOIN tbReturJDet ON tbReturJDet.fKodeBrg=tbKanvasJualDet.fKodeBrg
GROUP BY tbCustomer.fKodeSales, tbBarang.fKategori