Hi to everyone,
I have a database with three tables
books, authors and booksauthors.
Books has the fields idbook, title and thers
Authors has the fields idauthor,name and others
booksauthors has two fields idauthor and idbook
Every book can have up to 3 authors and in the booksauthors table there is a
row for every author of the book. If book 3 has authors 4,5 and 7 I have
three rows (3,5) (3,4) and (3,7)
Can anyone tell me what is in mysql the query to get on a single line
book,author1,author2, author3?
Thanks to everyone

Antonio Bernabei

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to