SELECT tbl_Products.IE, tbl_Products.Gemi, tbl_Products.UrunKod, tbl_Products.Miktar,
NZ((SELECT SUM(s.Sevk) FROM tbl_Sales s WHERE s.isEmri = tbl_Products.IE), 0) AS TotalSalesSevk,
NZ((SELECT SUM(l.Sevk) FROM tbl_logistic l WHERE l.tedIE = tbl_Products.IE), 0) AS TotalLogisticsSevk
FROM tbl_Products;
şeklinde deneyin