具体语法如下:
Create view newtable
AS
select * from table1
union all( ALL代表重复,去掉ALL即不重复)
select * from table2
...........
conditions
当table1或table2出现任何变动时,newtable视图将关联影响
具体语法如下:
Create view newtable
AS
select * from table1
union all( ALL代表重复,去掉ALL即不重复)
select * from table2
...........
conditions
当table1或table2出现任何变动时,newtable视图将关联影响