现有三张表:
需求:查询学生学号,学生姓名,学生班级,学生系别。
SELECT t_student.sid,t_student.sname,t_class.classname,t_department.depname
FROM t_student
LEFT JOIN t_class
ON t_student.sclass=t_class.id
LEFT JOIN t_department
ON t_student.sDepartment=t_department.id
查询结果: