I have a db with three tables - books, sections, and a joining table.
The normal way of getting a many to many relationship (i.e. one book
may belong to many sections, and one section may contain many books)
I want to extract the data with a single row for each book so that I
only retrieve the first section description for any book. (e.g. title,
author, section, description)
Structure as follows:
tbl_book
book_id, title, author, description etc...
tbl_section
section_id, section_desc
tbl_book_section
book_id, section_id
DBA is away and I can't figure this out at all...any help gratefully
received.