如题所述
假设三张表结构一样,题主可以参考下列sql语句,A表与B表union,然后将联合后的结果集再与C表union all
select t.* from
(select * from A union select * from B) t
union all
select * from C;
select t.* from
(select * from A union select * from B) t
union all
select * from C;
温馨提示:答案为网友推荐,仅供参考