many-to-many relationship problem

[Anon]

I have many-to-many situation in this case.
There is a two primar tables: "Books" and "Authors". Some Authors are authors of few books, and some books have a few authors.
I created third table "books_authors_rel" where can store many-to-many records. But, i need SQL query where i will get results for one book in one row, and in the same row all authors for this book. Can i get this? Or is my approach wrong? I tried:

select authors.name, books.title
from books,authors,books_authors_rel
where books.bookID=books_authors_rel
and authors.authorID=books_authors_rel
.author_id
Normally I get many duplicate books rows where that book have few authors

Thanks

[nostradamus]

you ment

select authors.name, books.title
from books,authors,books_authors_rel
where books.bookID=books_authors_rel.book_ID
and authors.authorID=books_authors_rel
.author_id

or am I wrong?
You wont get all the authors for one book in one row, you will get all the authors that belong to one book as datasets, so if you have stored :
book1 with the authors a1, a2, a3
and book2 with the authors a2, a4, a5
then you will get :
a1 book1
a2 book1
a3 book1
a2 book2
a4 book2
a5 book2

to get all the authors for one book in one row, you have to use php.
write a loop over all the books, and the make a select over the authors that belong to the book.
with a nother loop you can write an array in wich you the content :
book1, a1, a2, a3

and

book2, a2, a4, a5

live long and prosper ;-),
Nostr@damus.

[Anon]

Please would you like to be more specific about your sentence: "and the make a select over the authors that belong to the book.
with a nother loop you can write an array in wich you the content "