1、两个表的内容合并成一个(纵向)
union/union all
2、两个表的内容合并成一个(横向)
sql :
select * from A into table
select * from B into table
create view v_table as
select * from table
1、两个表的内容合并成一个(纵向)
union/union all
2、两个表的内容合并成一个(横向)
sql :
select * from A into table
select * from B into table
create view v_table as
select * from table