这题一定要用join连表,from之后并列表名跟三个条件过不了。
select a.*,b.score,b.CId
from student a join sc b
on a.SId=b.SId join course c
on b.CId=c.cId join teacher d
on c.TId=d.tId
where d.Tname='张三'
order by score desc
limit 0,1
这题一定要用join连表,from之后并列表名跟三个条件过不了。
select a.*,b.score,b.CId
from student a join sc b
on a.SId=b.SId join course c
on b.CId=c.cId join teacher d
on c.TId=d.tId
where d.Tname='张三'
order by score desc
limit 0,1