两个不同id的结果表合并到一张表里,结果在同一列:
1.创建两个结果表
2.只使用union是这种结果,然而在 t_id里有重复的id,这不是我们想要的结果
select * from t1
union
select * from t2
3.需要加一个函数:listagg within group,最终结果为:
select t_id as id,listagg(t_name,',')within group(order by t_id) as value from
(select * from t1
union
select * from t2
)group by t_id;