涉及到的两个表: 代码如下:
select sno as 学号,sname as 姓名,sex as 性别,mname as 专业 from stu,major where stu.mno=major.mno and mname in ('计算机工程','软件工程') order by sno;