联接两个表select * from 表1 inner join 表2 on 表1.id=表2.id连接两个表create view 视图1asselect * from 表1union allselect * from 表2