主题：数据库统计

请提供实例测试

举一个具体的批号说明一下，比如上面说的【实际销售数字是6件】，这个6是怎么查的？

试试

select c.批次号,c.供货商,c.配货数,d.销售数 from (SELECT {SDPHDMX}.DJBH AS 批次号, {GONGHUOSHANG}.GHSDM ,{GONGHUOSHANG}.GHSMC AS 供货商, SUM({SDPHDMX}.SL) AS 配货数 FROM {SDPHD} INNER JOIN {SDPHDMX} ON {SDPHD}.DJBH = {SDPHDMX}.DJBH INNER JOIN {shangpin_A} ON {SDPHDMX}.SPDM = {shangpin_A}.SPDM INNER JOIN {GONGHUOSHANG} ON {SHANGPIN_A}.GHSDM = {GONGHUOSHANG}.GHSDM  GROUP BY {SDPHDMX}.DJBH,{GONGHUOSHANG}.GHSDM ,{GONGHUOSHANG}.GHSMC ) as c inner join (select a.GHSDM, SUM(fQuantity) AS 销售数 from {shangpin_A} as a inner join {SG_Gatherings} as b on a.SPDM = b.vstyle group by a.GHSDM) as d on c.GHSDM = d.GHSDM  ORDER BY c.批次号 DESC

感觉没有办法匹配数据。就以11楼的PA300000041为例，哪些销售数据是属于PA300000041的？怎么关联起来的？

问题就在这，这2个表实际关联起来的数据，PA300000041的销售数就是33。所以如果33不是结果，那么仅仅这样关联肯定是不对的

多表关联查询和直接查询结果肯定不是完全一样的。不管怎么样，都说明这些表之间的数据关联肯定都有问题，无法得出正确的销售数

那就加到关联条件里

 ....inner Join (Sel ect a.DJBH, SUM(fQuantity) As 销售数 From {SDPHDMX} As a inner Join {SG_Gatherings} As b On a.SPDM = b.vstyle And a.GG1DM = B.VCOLOR And a.GG2DM = B.VSIZE Group By a.DJBH) As d On c.DJBH= d.DJBH Order By c.批次号 DESC

{SDPHDMX}也有SPDM ，直接和SG_Gatherings关联就行，没有必要再关联其它表