作者On1earth (小浅)
看板Database
标题[SQL ] 排序两个子查询计算出来的值
时间Wed Nov 3 22:55:37 2010
DBMS 是 MS SQL 2000
Table1 Table2 Table3
id Product id BuyItem id SellItem
========= ============= ==============
1 AAA 1 5 1 5
2 BBB 1 3 2 4
3 CCC 2 4
Table1是商品名称，Table2是买进多少数量，Table3是卖出多少数量
我想要计算Table2与Table3各商品总和，然後用买进与卖出数是否相等来排序，
这是我目前的写法
SELECT A.*,
(SELECT SUM(BuyItem) FROM Table2 AS B WHERE A.id=B.id) AS BuyCount,
(SELECT SUM(SellItem) FROM Table3 AS C WHERE A.id=C.id) AS SellCount
FROM Table1 AS A
ORDER BY (CASE WHEN BuyCount=SellCount THEN '1' ELSE '2' END)
可是 ORDER BY (CASE WHEN BuyCount=SellCount 这段会错误，
请问大家这个地方要怎麽改呢？
谢谢！
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.132.189.217