2019.12.04 数据库连接

/*联合查询(查询时用where,order,group需用tno ,tname,Tsex)*/
SELECT tno ,tname,Tsex FROM teacher
UNION
SELECT sno,sname,ssex FROM student01
/*查询所有教师的同学的name、sex、、birthday*/
SELECT tname AS NAME,Tsex AS sex,Tbirthday AS birthday FROM teacher
UNION
SELECT sname,ssex,Sbirth FROM student01;

2019.12.04 数据库连接

原文：https://www.cnblogs.com/l1314/p/11980877.html