作者ruby0104 (:))
看板Database
标题Re: [SQL ] 请问不同资料表相同栏位数值相加
时间Sat Sep 8 10:31:18 2007
※ 引述《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