问题找到了,应该是因为配货单里面有颜色和尺码,但是我没有匹配
![dvubb 图片点击可在新窗口打开查看](skins/default/filetype/png.gif)
此主题相关图片如下:13.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2024-5/2024513942172866.png)
两张表都有颜色和尺码,这种该怎么匹配
{shangpin_A} As a{SG_Gatherings} As b
{GONGHUOSHANG}.GHSMC) As c
不是a,表不对,是{SDPHDMX}
{SDPHDMX}也有SPDM ,直接和SG_Gatherings关联就行,没有必要再关联其它表
认真看看25楼咯
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