mysql连表题
#小虎的数学成绩是多少
select s.sid,s.name,c.cname,ss.score from students as s,courses as c,scores as ss
where s.sid = ss.sid and c.cid = ss.cid and s.name = ‘小虎’ and c.cname = ‘数学’
#马老师都教了那些课程
select t.tname,c.cname from teachers as t,courses as c
where t.tid = c.tid and t.tname = ‘马老师’
#数学最高分的是哪个同学
SELECT s.name,ss.score from students as s,courses as c,scores as ss
where s.sid = ss.sid and c.cid = ss.cid and c.cname = ‘数学’ order by ss.score ASC LIMIT 1