[Meen2]

PHP كود :

SELECT TBL_Products_Received_Details.Product_S_N   AS 'Product SN', 
       SUM(TBL_Products_Received_Details.Quantity) AS 'Total Received', 
       SUM(TBL_Outgoing_Products_Details.Quantity) AS 'Total Outgoing' 
FROM   TBL_Products_Received_Details 
INNER  JOIN TBL_Outgoing_Products_Details 
       ON TBL_Outgoing_Products_Details.Product_S_N = TBL_Products_Received_Details.Product_S_N 
GROUP  BY TBL_Products_Received_Details.Product_S_N