不知这段SQL语句的意思,帮忙解决SELECT TOP 5
CMRC_OrderDetails.ProductID,
CMRC_Products.ModelName,
SUM(CMRC_OrderDetails.Quantity) as TotalNumFROM
CMRC_OrderDetails
INNER JOIN CMRC_Products ON CMRC_OrderDetails.ProductID = CMRC_Products.ProductIDWHERE OrderID IN
(
/* This inner query should retrieve all orders that have contained the productID */
SELECT DISTINCT OrderID
FROM CMRC_OrderDetails
WHERE ProductID = @ProductID
)
AND CMRC_OrderDetails.ProductID != @ProductID GROUP BY CMRC_OrderDetails.ProductID, CMRC_Products.ModelName ORDER BY TotalNum DESC
CMRC_OrderDetails.ProductID,
CMRC_Products.ModelName,
SUM(CMRC_OrderDetails.Quantity) as TotalNumFROM
CMRC_OrderDetails
INNER JOIN CMRC_Products ON CMRC_OrderDetails.ProductID = CMRC_Products.ProductIDWHERE OrderID IN
(
/* This inner query should retrieve all orders that have contained the productID */
SELECT DISTINCT OrderID
FROM CMRC_OrderDetails
WHERE ProductID = @ProductID
)
AND CMRC_OrderDetails.ProductID != @ProductID GROUP BY CMRC_OrderDetails.ProductID, CMRC_Products.ModelName ORDER BY TotalNum DESC
解决方案 »
- 求有用过的开源cms
- 关于用VS2005做网站后不能在浏览器浏览出来的问题
- GRIDVIEW更新问题,提示不是有效INT32
- 判断iframe中的子页面是否存在
- 做一个功能比较丰富的网页上用的聊天室(有一般常见聊天室的主要功能),需要用到什么技术?
- 这个正则表达式该如何写呢?
- 水晶报表打包问题!vs2003+水晶报表10如何打包?
- 100分求《专家门诊--asp.net开发答疑200问》
- 帮帮忙啊:用户 'GDUT-PWM\ASPNET' 登录失败
- DropDownList数据绑定时,能不能把两个字段合在一起显示啊?
- 中文环境开发的Web应用程序在英文服务器上小数点变成逗号的问题,高手及有经验都请进,连接原来一贴共200分,解决即全给.
- 为什么我的iis找不到包含偶数中文文件名的url?...........在线等!
(
/* This inner query should retrieve all orders that have contained the productID */
SELECT DISTINCT OrderID
FROM CMRC_OrderDetails
WHERE ProductID = @ProductID
)
AND CMRC_OrderDetails.ProductID != @ProductID GROUP BY CMRC_OrderDetails.ProductID, CMRC_Products.ModelName ORDER BY TotalNum DESC
条件当中怎么也有SELECT .......