n a.SPDM = b.vstyle And a.GG1DM = B.VCOLOR And a.GG2DM = B.VSIZE Group By a.DJBH) As d On c.批次号= d.DJBH Order By c.批次号 DESC
32楼
BG小白 发表于:2024/5/13 12:34:00
{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.批次号= d.DJBH and c.供货商 = d. (好像这里需要添加一个供货商代码或者名称才对) Order By c.批次号 DESC
不知道该怎么写,因为只按照单据号来的话,还是错的,一个单据里面实际有N个供货商
[此贴子已经被作者于2024/5/13 12:34:50编辑过]
33楼
有点蓝 发表于:2024/5/13 13:45:00
.........As c inner Join (S elect A.DJBH,k.GHSDM , 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 inner join {shangpin_A} as k on a.SPDM =k.SPDM Group By a.DJBH,k.GHSDM ) As d On c.批次号= d.DJBH and c.供货商 = d.GHSDM Order By c.批次号 DESC