SELECT a.p_id,a.product,SUM(a.qty) as receive FROM plus2_product_receive a GROUP BY a.p_id

SELECT p_id,product,SUM(qty)AS Quantity,FORMAT(SUM(price),2) AS Total_price 
FROM `plus2_invoice_dtl` GROUP BY p_id

SELECT inv_id, SUM(qty)AS Quantity_sold,FORMAT(SUM(price),2) AS Total_price 
FROM `plus2_invoice_dtl` GROUP BY inv_id;

SELECT a.p_id,a.product,SUM(a.qty) as receive , COALESCE(b.sold,0) AS sold, 
(SUM(a.qty) - COALESCE(b.sold,0)) AS stock FROM plus2_product_receive a
LEFT JOIN
(SELECT p_id,product,SUM(qty) AS  sold FROM `plus2_invoice_dtl` GROUP BY p_id) b 
ON a.p_id=b.p_id
GROUP BY a.p_id


SELECT p_id,product,receive,sold,stock FROM (
SELECT a.p_id,a.product,SUM(a.qty) AS receive , COALESCE(b.sold,0) AS sold, (SUM(a.qty) - COALESCE(b.sold,0)) AS stock
FROM plus2_product_receive a
LEFT JOIN
(SELECT p_id,product,SUM(qty) as sold FROM `plus2_invoice_dtl` GROUP BY p_id) b  ON a.p_id=b.p_id
GROUP BY a.p_id) as t1 WHERE stock >10;



SELECT t2.p_id,t2.p_name,receive,sold,stock,t2.price FROM (
SELECT a.p_id,a.product,SUM(a.qty) AS receive , COALESCE(b.sold,0) AS sold, 
(SUM(a.qty) - COALESCE(b.sold,0)) AS stock FROM plus2_product_receive a
LEFT JOIN
(SELECT p_id,product,SUM(qty) AS sold FROM `plus2_invoice_dtl` GROUP BY p_id) b 
 ON a.p_id=b.p_id
GROUP BY a.p_id) AS t1 
LEFT JOIN 
plus2_product as t2 on t1.p_id=t2.p_id 
WHERE stock >10