select
--用于分组列
access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName
,attType.AttributeTypeNameE from dbo.Stock_Accessories as access ,
dbo.Stock_AttributeType as attType
where access.AttributeTypeId=attType.AttributeTypeID and AccessoryTypeId=31
and AttType.AttributeTypeNameE !='Apple iOS Device' and AttType.AttributeTypeNameE !='Mac book'
---排序 ID
order by access.accessoriesIDgroup by access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName,
attType.AttributeTypeNameE
--用于分组列
access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName
,attType.AttributeTypeNameE from dbo.Stock_Accessories as access ,
dbo.Stock_AttributeType as attType
where access.AttributeTypeId=attType.AttributeTypeID and AccessoryTypeId=31
and AttType.AttributeTypeNameE !='Apple iOS Device' and AttType.AttributeTypeNameE !='Mac book'
---排序 ID
order by access.accessoriesIDgroup by access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName,
attType.AttributeTypeNameE
--用于分组列
access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName
,attType.AttributeTypeNameE from dbo.Stock_Accessories as access ,
dbo.Stock_AttributeType as attType
where access.AttributeTypeId=attType.AttributeTypeID and AccessoryTypeId=31
and AttType.AttributeTypeNameE !='Apple iOS Device' and AttType.AttributeTypeNameE !='Mac book'
group by access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName,
attType.AttributeTypeNameE
---排序 ID
order by access.accessoriesID
--用于分组列
access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName
,attType.AttributeTypeNameE from dbo.Stock_Accessories as access ,
dbo.Stock_AttributeType as attType
where access.AttributeTypeId=attType.AttributeTypeID and AccessoryTypeId=31
and AttType.AttributeTypeNameE !='Apple iOS Device' and AttType.AttributeTypeNameE !='Mac book' group by access.AccessoryTypeId,
access.AttributeTypeId,
attType.AttributeTypeName,
attType.AttributeTypeNameE---排序 ID
order by access.accessoriesID
ORDER BY 子句中的列 "dbo.Stock_Accessories.AccessoriesID" 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。