老是要用的时候都要查资料,现在记录一下备忘。
现有四张表如下:
tb_class
tb_course
tb_students
tb_score
最简单的两张表联表查询:
SELECT StudentName,AGE,tb_class.`ClassName`
FROM tb_students
JOIN tb_class
ON tb_students.`CLASS`=tb_class.`ID`;
结果:
三张表的查询,并且增加查询条件
SELECT tb_students.`StudentName`,tb_course.`CourseName`,Score
FROM tb_score
JOIN tb_students
ON tb_students.`ID`=tb_score.`StudentID`
JOIN tb_course
ON tb_course.`ID`=tb_score.`CourseID`
WHERE tb_students.`StudentName`='Alpha'
AND tb_score.`Score`<60;
查询结果: