mysql query for sum two table data

[nishita_1]

please provide me sql query for below output sum query please help me

[pritaeas]

Probably something like this:

SELECT * 
FROM (
    SELECT product_id, SUM(quantity) AS purchase
    FROM purchase 
    GROUP BY product_id
) P
JOIN (
    SELECT product_id, SUM(quantity) AS sale
    FROM sale
    GROUP BY product_id
) S ON S.product_id = P.product_id

[nishita_1]

please any one help me

[nishita_1]

Dear sir please help me, here product id 4 is not entry to sale column but i want to show purchase column result as like below picture. sir please help be as before code. thanks

[Santanu.Das]

You can use Union All Clause.

Your sql syntax should be

SELECT tt.product_id, tt.purchase, tt.sale
FROM (SELECT product_id, SUM(quantity) AS purchase, SUM(0) AS sale FROM purchase GROUP BY product_id) 
UNION ALL (SELECT product_id, SUM(0) AS purchase, SUM(quantity) AS sale FROM sale GROUP BY product_id) tt