Re: [SQL ] 合併資料表
/
select a.a, a.b, a.c, b.b, b.c, c.b, c.c
from
(select year a, count(id) b, sum(amea) c
from t1
group by year) a,
(select year a, count(id) b, sum(amea) c
from t2
group by year) b,
(select year a, count(id) b, sum(amea) c
from t3
group by year) c
where a.a = b.a(+) and b.a = c.a(+)
order by to_number(a.a) desc
/
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.233.168.82
推
10/21 10:11, , 1F
10/21 10:11, 1F
討論串 (同標題文章)