sql query problem with n:m relation

[michael_hauser]

this might be an easy problem, but although i tried hard, i didn't manage to solve it, sorry:
i have a problem to produce a query selecting the author's name and his books in my little library database.
i have the following tables: author (containing id and name), name2book (containing author_id and book_id) and book (containing book_id and title).

now i want to output a table showing all books one author ($author_name) has written in the form:

author booktitle1
author booktitle2
author booktitle3
...

any help is welcomed, thanks,
Michael

[Anon]

select * from authors a, books b where authors.id=1 and a2b.aid=a.id
and a2b.bid=b.id;

will select all the books for author id number 1

[Anon]

SELECT author.name, book.title
FROM author INNER JOIN
name2book ON author.id = name2book.author_id INNER JOIN
book ON name2book.book_id = book.book_id

i belive this is the correct sql. hope is helps

[michael_hauser]

thanx, that should work.
i first tried
[...] WHERE authors.authName = $author_name\'
AND name2book.authID=authors.authID;
but that didn\'t work.