Mysql:两个表变一个纵表

情形1(只取合集字段)

教师表

学生表

需求: 查学校所有人员信息(包括老师)

select teacher_name as user_name, teacher_gender as user_gender from t_teacher_info as t 
UNION 
select user_name as user_name, user_gender as USER_GENDER from t_user_info s

执行结果

情形2(取并集字段)

表A

表B

目标:

select A1, A2, A3, A4, "" as A5, "" as A6 from a UNION select "" as A1, "" as A2, A3,A4,A5,A6 from b