union----合并结果集
select sName from students union select tName from Teachers;
select sName from students union all select tName from Teachers;
MySQL数据库:合并结果集
原文:https://www.cnblogs.com/yanlzy/p/11909159.html