仅以多对多关系检索第一行

FROM tbl_book AS B1 JOIN （SELECT book_id，MIN（section_id）AS section_id FROM tbl_book_section GROUP BY book_id）AS S1 ON B1.book_id = S1 .book_id 加入tbl_section AS S2 ON S1.section_id = S2.section_id Try this. I''m assuming that by "first section" you mean the lowest numbered section_id. SELECT B1.book_id, B1.title, B1.author, B1.description, S2.section_id, S2.section_desc FROM tbl_book AS B1 JOIN (SELECT book_id, MIN(section_id) AS section_id FROM tbl_book_section GROUP BY book_id) AS S1 ON B1.book_id = S1.book_id JOIN tbl_section AS S2 ON S1.section_id = S2.section_id 这篇关于仅以多对多关系检索第一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！