学习笔记（2):MySQL数据库从入门实战课-表连接（内连接、外连接、自连接）

立即学习:https://edu.csdn.net/course/play/27328/362530?utm_source=blogtoedu

内链接：select a.id as 学号,a.name as 姓名,b.job as 科目,b.fraction as 分数
from student a 
join  subject b on (a.id = b.code)

内链接:select a.id as 学号,a.name as 姓名,b.job as 科目,b.fraction as 分数
from student a , subject b where a.id = b.code

左连接:select a.*,b.*
from student a 
left join  subject b on a.id = b.code