SELECT tbl_Products.IE, tbl_Products.Gemi, tbl_Products.UrunKod, tbl_Products.Miktar,

    (SELECT SUM(s.Sevk) FROM tbl_Sales s WHERE s.isEmri = tbl_Products.IE) AS TotalSalesSevk,

    (SELECT SUM(l.Sevk) FROM tbl_logistic l WHERE l.tedIE = tbl_Products.IE) AS TotalLogisticsSevk

FROM tbl_Products;