create or replace view uia.view_uia_user as
(select t1.id,t1.user_name,t1.user_pass,t1.user_idcard,t1.user_alias,t1.user_email,t1.user_studentid,t1.user_workerid,t1.user_type,t1.user_phonenumber,t1.user_status,'uia_user' fromtab from uia.uia_user t1
union
select t2.id,t2.user_name,t2.user_pass,t2.user_idcard,t2.user_alias,t2.user_email,t2.user_studentid,t2.user_workerid,t2.user_type,t2.user_phonenumber,t2.user_status,'uia_user_temp' fromtab from uia.uia_user_temp t2);
fromtab 字段是静态值
union 连接