SELECT
l.limitId, l.limitName, l.limitURL, m.ModelName,o.OperateName
FROM limits l
LEFT JOIN model m ON m.ModelId=l.limitModelId
LEFT JOIN operate o ON o.OperateId=l.limitOperateNameId;
用户表user:
user_id | user_name | user_sex |
100111 | 佳佳 | 女 |
课程表subject:
subject_id | subject_name | achievement | user_number |
111 | 计算机科学与技术 | 99 | 100111 |
学院表college:
college_id | college_name | subject_number |
201 | 网络工程学院 | 111 |
select
u.user_id, u.user_name,u.user_sex,c.college_name,s.subject_name, s.achievement
from user u
LEFT JOIN subject s ON s.user_number=u. user_id
LEFT JOIN college c ON c.subject_number=s.subject_id;
三表关联查询结果:
user_id(学号) | user_name(姓名) | user_sex(性别) | college_name(学院) | subject_name(学科) | achievement(成绩) |
100111 | 佳佳 | 女 | 网络工程学院 | 计算机科学与技术 | 99 |