select id,'A' as type from tableA
union all
select id,'B' as type from tableB
create view ab
as
select id,'A' type from a
union all
select id,'B' type from b
select id,type='A' from tableA
union all
select id,type='B' from tableB
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024