SQL高级查询

三表内连接

    select s.sname,t.tname,b.subjectName from student s 
   
    inner join teacher t on(s.tid = t.tid)
   
    inner join subject b on(b.subjectNo = t.subjectNo);

in查询

select * from  students where sid in(select sid from result  where subjectNo=
(selcet form subject where subjectName ='HTML') 
and studentResult>60);