Re: [SQL ] 排序兩個子查詢計算出來的值

[daniel1205 (艾琳是我最愛的人!!)]

SELECT B.BuyCount-C.SellCount DiffCount,
       B.BuyCount,
       C.SellCount,
       A.*
  FROM Table1 A
       LEFT JOIN (SELECT id, SUM(BuyItem) BuyCount
                    FROM Table2
                GROUP BY id) B ON A.id = B.id
       LEFT JOIN (SELECT id, SUM(SellItem) SellCount
                    FROM Table3
                GROUP BY id) C ON A.id = C.id
ORDER BY 1





※ 引述《On1earth (小淺)》之銘言：

: 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: 118.168.136.105
推 On1earth:謝謝d大，這樣可以執行