三表关联查询:mysql三表关联查询[朗读]

比如有三张表,student,teacher,project:1.第一种方法:select*fromstudent,teacher,projectwherestudent.id=teacher.sidandstudent.id=project.sid;2.第二种:select*fromstudentinnerjointeacheronstudent.id=teacher.sidinnerjoinprojectonstudent.id=project.sid;