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