推 insert:試過修改後已可用 謝謝:-) 10/21 10:11
/
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