三表關聯查詢:mysql三表關聯查詢[朗讀]

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