1. usr_user表
2.usr_user_temp表
4.union 语句
SELECT u.LOGIN_NAME AS "NAME",u.MOBILE AS "MOBILE" FROM test.usr_user u
UNION
SELECT uut.LOGIN_NAME AS "NAME",uut.MOBILE AS "MOBILE" FROM test.usr_user_temp uut
结果:
结论:
1.列的数量在两个查询语句中要相同
2.相等于数学中的并集
1. usr_user表
2.usr_user_temp表
4.union 语句
SELECT u.LOGIN_NAME AS "NAME",u.MOBILE AS "MOBILE" FROM test.usr_user u
UNION
SELECT uut.LOGIN_NAME AS "NAME",uut.MOBILE AS "MOBILE" FROM test.usr_user_temp uut
结果:
结论:
1.列的数量在两个查询语句中要相同
2.相等于数学中的并集
转载于:https://my.oschina.net/nixi0608/blog/717966