两表合并时 使用union all 必须给表设置别名、还得注意明确字段
e.g:
select userInfo1.userName as uName,userInfo2.passWord as pw from (select * from user) userInfo1
union all
select userInfo2.userName as uName,userInfo2.passWord as pw from (select * from user) userInfo2
两表合并时 使用union all 必须给表设置别名、还得注意明确字段
e.g:
select userInfo1.userName as uName,userInfo2.passWord as pw from (select * from user) userInfo1
union all
select userInfo2.userName as uName,userInfo2.passWord as pw from (select * from user) userInfo2