如图,三个表
MySQL 语句:
select s.no,name,subname,score
from stu s
inner join score sc on s.no=sc.no
LEFT JOIN sub sb
on sc.subno=sb.subno;
结果如图
如图,三个表
MySQL 语句:
select s.no,name,subname,score
from stu s
inner join score sc on s.no=sc.no
LEFT JOIN sub sb
on sc.subno=sb.subno;
结果如图