五表联查t_person,t_person_position,t_person_position_level,t_person_education,t_person_degree
时间: 2024-06-04 18:11:06 浏览: 49
5多表查询数据.sql
SELECT p.*, pp.position_name, ppl.level_name, pe.education_name, pd.degree_name
FROM t_person p
LEFT JOIN t_person_position pp ON p.position_id = pp.position_id
LEFT JOIN t_person_position_level ppl ON p.position_level_id = ppl.level_id
LEFT JOIN t_person_education pe ON p.education_id = pe.education_id
LEFT JOIN t_person_degree pd ON p.degree_id = pd.degree_id;
阅读全文