12-10-22, 01:01 PM
(12-10-22, 09:16 AM)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
السلام عليكم اخوي
شكرا جداً ليك ولكن الاستعلام مش بينفذ اللي محتاجه وايضاً بيجيب مجموع الارقام غلط
بتمني حد يساعدني في حل المشكلة دي .. شكراً مقدماً
