创建视图

创建视图

CREATE VIEW `vw_chengben` 
AS
(
select * from tb_chengben_neibu 
union all 
select * from tb_chengben_waibu 
);





CREATE VIEW `vw_shouru` 
AS
(
select * from tb_shouru_neibu 
union all 
select * from tb_shouru_waibu 
);