关于DataGrid的问题,请各位兄弟门帮帮忙啊!感谢啊

Question

打错了 ALTER PROCEDURE 应该是Create  PROCEDURE  请大家帮忙啊!!!

Answer 1

try these out:
select  OrderDetail.OrderID,
Orders.UserID,
SUM(Cast((OrderDetail.UnitCost*OrderDetail.BookQuantity) as Money))   as   TotalMoney
from  OrderDetail ,  Orders
GROUP BY OrderDetails.OrderID, Orders.UserID,
HAVING OrderDetail.OrderID=Orders.OrderID

Answer 2

用上面的也不行啊,出错啊,说OrderDetail.OrderID=Orders.OrderID在having 子句中无效,因为该列既不包含在聚合函数中,也不包含在group by子句中..