视图_多个表拼接按ID求和错误翻倍

这个肯定是你业务关联 只有你清楚 应该是某个行数  的业务逻辑你还没弄好你把数据全部出来看一睛就知道了

供参考用：还差数量  用公式字段

1. SELECT
   
2. A1.ID as 物料清单子表ID,
   
3. A1.数量 as 需求数量,
   
4. (SELECT  IFNULL(sum(A2.数量),0) FROM 采购订单子表 as A2 WHERE A1.ID = A2.物料清单子表ID group by A2.物料清单子表ID) as 采购数量 ,
   
5. (SELECT  IFNULL(sum(A3.计划到货数量),0)  FROM 计划到货通知子表 as A3 WHERE A1.ID = A3.物料清单子表ID group by A3.物料清单子表ID) as 计划到货数量,
   
6. (SELECT  IFNULL(sum(A4.到货数量),0)  FROM 到货报检子表 as A4 WHERE A1.ID = A4.物料清单子表ID group by A4.物料清单子表ID) as 到货数量,
   
7. (SELECT  IFNULL(sum(A5.不合格数量),0)  FROM 检验报告子表 as A5 WHERE A1.ID = A5.物料清单子表ID group by A5.物料清单子表ID) as 不合格数量
   
8. FROM 物料清单子表 as A1
   
9. 
   

复制代码