Re: [SQL ] 請問不同資料表相同欄位數值相加
※ 引述《alexcwtzeng (狂瀉不止)》之銘言：
: group by 不能跟 order by 一起使用哦
應該是可以一起用....
derived table 要有各名字...
$sql="SELECT number,SUM(count) FROM
(SELECT * FROM Table1 UNION ALL SELECT * FROM Table2 UNION ALL
SELECT * FROM Table3) a
group by number order by SUM(count) desc";
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 71.132.222.249
討論串 (同標題文章)