select * from major_subject_discussion a join (select id from fa_user a join (select class from major_subject_classes a join (select subject_no from major_subject_chapter where subject_chapter_no = 'chapter_4') b on a.subject_no = b.subject_no) b on a.class = b.class) b on a.user_id = b.id where subject_chapter_no = 'chapter_4'
四表关联,使用join关键字,可以进行多表关联。
分解开:
第一个子查询
select subject_no from major_subject_chapter where subject_chapter_no = 'chapter_4'
第二个子查询
select class from major_subject_classes a join (select subject_no from major_subject_chapter where subject_chapter_no = 'chapter_4') b on a.subject_no = b.subject_no
通过join关键字,进行两表关联。
之后也是一样,来通过join达到子查询多表关联的效果。