oracle三表联合查询sql语句,SQL三表联合查询 - BBF的第一次尝试的个人空间 - OSCHINA - 中文开源技术交流社区...

resume表         id

education表    id，resume_id

work表  id,resume_id

表结构如上所示

关系为:

education.resume_id = resume.id

work.resume_id = resume.id

表中数据下所示

resume表

educaiton表

work表

写了一个联合查询语句如下

SELECT prt._id AS resume_id,eet._id AS education_id,wet._id AS WORK_id

FROM

(person_resume_t prt LEFT JOIN education_expirence_t eet ON prt._id=eet.resume_id)

LEFT JOIN work_experience_t wet ON prt._id=wet.resume_id

AND  prt.user_info_id=(SELECT pit._id FROM person_info_t pit WHERE pit.user_id='1');

返回的结果为

work表中id为3的数据不见了？？？

如果想要查询结果中子表的id不重复，这个sql语句应该如何来写？！