Re: [SQL ] 排序兩個子查詢計算出來的值
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
推
11/04 21:29, , 1F
11/04 21:29, 1F
討論串 (同標題文章)
本文引述了以下文章的的內容：
完整討論串 (本文為第 2 之 2 篇)：