Select Materials.ID, Materials.[name], Materials.spec, ProPlaDocBom.quantity,
Materials.unit, Materials.warehouse, GETDATE()
From Materials
Right Join
(Select matID, Sum(quantity)
From TempProPlaDocBom
Group By matID) As ProPlaDocBom
On Materials.ID = ProPlaDocBom.matID
Materials.unit, Materials.warehouse, GETDATE()
From Materials
Right Join
(Select matID, Sum(quantity)
From TempProPlaDocBom
Group By matID) As ProPlaDocBom
On Materials.ID = ProPlaDocBom.matID
服务器: 消息 8155,级别 16,状态 2,行 1
没有为第 2 列(属于 'ProPlaDocBom')指定列。
Materials.unit, Materials.warehouse, GETDATE()
From Materials
Right Join
(Select matID, Sum(quantity) as quantity
From TempProPlaDocBom
Group By matID) As ProPlaDocBom
On Materials.ID = ProPlaDocBom.matID
Materials.unit, Materials.warehouse, GETDATE()
From Materials
Right Join
(Select matID, Sum(quantity) 列名--这个后面要加上列名
From TempProPlaDocBom
Group By matID) As ProPlaDocBom
On Materials.ID = ProPlaDocBom.matID
select* from (Select Materials.ID, Materials.[name], Materials.spec, ProPlaDocBom.quantity,
Materials.unit, Materials.warehouse, GETDATE()
From Materials) a
Right Join
(Select matID, Sum(quantity)
From TempProPlaDocBom
Group By matID) As ProPlaDocBom
On a.ID = ProPlaDocBom.matID
xyxfly(小虾米......BS问题解决不结贴)
------------------------------------------
有同样感受,希望楼主能结贴!哈!
为什么连接查询要给个列名,单独这样是没问题的:
Select matID, Sum(quantity)
From TempProPlaDocBom
Group By matID
Sum(quantity)------------这个已经没字段名了!所以要给个给他,让其他好调用!
From TempProPlaDocBom
Group By matID
服务器: 消息 107,级别 16,状态 2,行 1
列前缀 'ProPlaDocBom' 与查询中所用的表名或别名不匹配。