[SQL ] union ORDER BY 的問題
我想要搜尋四個table的count
SELECT count(a.Id)
FROM table_A AS A
UNION
SELECT count(B.Id)
FROM table_B AS B
UNION
SELECT count(C.Id)
FROM table_A AS C
UNION
SELECT count(D.Id)
FROM table_A AS D
並且四個TABLE有些微的WHERE條件不同,所以這種情況用UNION應該沒錯吧?
但是得到的結果,預設都幫我遞增排序了
但是我希望他結果是 A>B>C>D 照TABLE順序排就好
不曉得這情況如何解決呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.42.108.158
→
04/20 23:28, , 1F
04/20 23:28, 1F
→
04/21 00:00, , 2F
04/21 00:00, 2F