主题：数据库统计

问题找到了，应该是因为配货单里面有颜色和尺码，但是我没有匹配

表的结构是这样的

那就加到关联条件里

Sel ect c.批次号, c.供货商, c.配货数, d.销售数 From (Sel ect {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 (Sel ect a.GHSDM, SUM(fQuantity) As 销售数 From {shangpin_A} As a inner Join {SG_Gatherings} As b On a.SPDM = b.vstyle And {SDPHDMX}.GG1DM = B.VCOLOR And {SDPHDMX}.GG2DM = B.VSIZE Group By a.GHSDM) As d On c.GHSDM = d.GHSDM Order By c.批次号 DESC

 ....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

{shangpin_A} As a

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

此主题相关图片如下：16.png

认真看看25楼咯

S elect c.批次号, c.供货商, c.配货数, d.销售数 From (S elect {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 (S elect 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