34,587
社区成员
发帖
与我相关
我的任务
分享
select a.*,
'课程名'=c.coursename
from students a
inner join stuclass b on a.sno=b.sno
inner join class c on b.courseid=c.courseid
where c.coursename='密码学'
select a.*, c.coursename
from students a
inner join stuclass b on a.sno=b.sno
inner join class c on b.courseid=c.courseid
select a.*
from students a
inner join stuclass b on a.sno=b.sno
inner join class c on b.courseid=c.courseid
where c.coursename='密码学'