php - 如何在mysql中加入查询和计算？

Question

如何在mysql中加入查询和计算？

fab_in 表

fab_out 表

下面是我的查询

  SELECT fabric_in.fabric_id, fabric_in.fabric_date, fabric_in.fabric_order_qty, fabric_in.fabric_rejected_qty, fabric_in.fabric_rejected_reason, fabric_in.fabric_total_qty, fabric_in.fabric_company_name, fabric_out.fabric_out_qty 
    FROM fabric_out 
    RIGHT JOIN fabric_in 
ON fabric_out.fabric_id=fabric_in.fabric_id

结果查询

但我想要与 fabric_id 的总和关系，你能帮忙吗

Answer 1

SELECT 
    fabric_in.fabric_id, 
    fabric_in.fabric_date, 
    fabric_in.fabric_order_qty, 
    fabric_in.fabric_rejected_qty, 
    fabric_in.fabric_rejected_reason, 
    fabric_in.fabric_total_qty, 
    fabric_in.fabric_company_name, 
    SUM(fabric_out.fabric_out_qty) AS fabric_out_qty
FROM fabric_out 
RIGHT JOIN fabric_in 
ON fabric_out.fabric_id=fabric_in.fabric_id
GROUP BY fabric_in.fabric_id