select * from (SELECT BookShop_Orders.OrderID, BookShop_Orders.OrderDate,
Cast(SUM(BookShop_OrderDetails.Quantity * BookShop_Book.Price) AS money)
AS OrderTotal,
(CASE BookShop_Orders.Status WHEN 0 THEN '未发货' ELSE '已发货' END)
AS Status
FROM BookShop_Orders INNER JOIN
BookShop_OrderDetails ON
BookShop_Orders.OrderID = BookShop_OrderDetails.OrderID INNER JOIN
BookShop_Book ON
BookShop_Book.bookID = BookShop_OrderDetails.bookID
GROUP BY BookShop_Orders.OrderID, BookShop_Orders.OrderDate,
BookShop_Orders.Status) order by OrderDate ASC
Cast(SUM(BookShop_OrderDetails.Quantity * BookShop_Book.Price) AS money)
AS OrderTotal,
(CASE BookShop_Orders.Status WHEN 0 THEN '未发货' ELSE '已发货' END)
AS Status
FROM BookShop_Orders INNER JOIN
BookShop_OrderDetails ON
BookShop_Orders.OrderID = BookShop_OrderDetails.OrderID INNER JOIN
BookShop_Book ON
BookShop_Book.bookID = BookShop_OrderDetails.bookID
GROUP BY BookShop_Orders.OrderID, BookShop_Orders.OrderDate,
BookShop_Orders.Status) order by OrderDate ASC
解决方案 »
- 高分求!vs2010 C# Entity Framework 怎么使用Oracle 10g数据库啊!
- 【讨论】文件传输到底是用stream 还是 byte[]好
- 大家帮我来看一段C#天气起预报的代码啊。有点小问题
- 输出实数时,如何能留出正数的符号位为空格:例如正负522.30,输出负的为“-522.30”,输出正的为“ 522.30”。
- 控件拉伸问题
- c# 棋盘io问题
- 一个疑问,Duwamish是否采用面向对象编程
- C#中OnMouseWheel不能响应
- 解释一下这个不同F5和Ctrl+F5
- Vs2003使用的莫名恼火问题!!!??
- 为什么我的自动提示总是莫名其妙地消失?
- 请问哪位大侠有用C#做的有关GDI+方面的程序和资料,请提供参考,谢谢了
select * from (SELECT BookShop_Orders.OrderID, BookShop_Orders.OrderDate,
Cast(SUM(BookShop_OrderDetails.Quantity * BookShop_Book.Price) AS money)
AS OrderTotal,
(CASE BookShop_Orders.Status WHEN 0 THEN '未发货' ELSE '已发货' END)
AS Status
FROM BookShop_Orders INNER JOIN
BookShop_OrderDetails ON
BookShop_Orders.OrderID = BookShop_OrderDetails.OrderID INNER JOIN
BookShop_Book ON
BookShop_Book.bookID = BookShop_OrderDetails.bookID
GROUP BY BookShop_Orders.OrderID, BookShop_Orders.OrderDate,
BookShop_Orders.Status) as aorder by a.OrderDate ASC