select s.name,s.course,s.grade from student as s inner join student as t on s.name=t.namewhere s.courset.course 我想知道这段代码最后两句是什么意思?为什么又把student as t .

来源:学生作业帮助网 编辑:六六作业网 时间:2024/07/02 20:15:33
selects.name,s.course,s.gradefromstudentassinnerjoinstudentastons.name=t.namewheres.courset.course我想

select s.name,s.course,s.grade from student as s inner join student as t on s.name=t.namewhere s.courset.course 我想知道这段代码最后两句是什么意思?为什么又把student as t .
select s.name,s.course,s.grade from student as s inner join student as t on s.name=t.name
where s.courset.course 我想知道这段代码最后两句是什么意思?为什么又把student as t .

select s.name,s.course,s.grade from student as s inner join student as t on s.name=t.namewhere s.courset.course 我想知道这段代码最后两句是什么意思?为什么又把student as t .
本表与本表链接查询嘛