SELECT [MaterialType].[Type], sum([MaterialInfo].[counts]) AS totalcount, [MaterialInfo].[Re] FROM MaterialInfo, MaterialType, MaterialUnit WHERE [MaterialInfo].[UnitID]=[MaterialUnit].[ID] And [MaterialInfo].[TypeID]=[MaterialType].[ID] And [MaterialUnit].[Unit]='泵头' GROUP BY [MaterialInfo].[TypeID], [MaterialType].[Type], [MaterialInfo].[Re order by [MaterialType].[Type] 这样???
FROM MaterialInfo, MaterialType, MaterialUnit
WHERE [MaterialInfo].[UnitID]=[MaterialUnit].[ID] And [MaterialInfo].[TypeID]=[MaterialType].[ID] And [MaterialUnit].[Unit]='泵头'
GROUP BY [MaterialInfo].[TypeID], [MaterialType].[Type], [MaterialInfo].[Re
order by [MaterialType].[Type]
这样???