MYSQL Relation n-m

I have a database on MySql divided into 3 tables books (idbook, and other fields) author (idauthor, and other fields) bookauthor (idauthor,idbook) This is to have more than 1 author for every book How can I make a query to select on one row all the authors of abook? Thanks Antonio

Re: MYSQL Relation n-m

I have a database on MySql divided into 3 tables books (idbook, and other fields) author (idauthor, and other fields) bookauthor (idauthor,idbook) This is to have more than 1 author for every book How can I select with a query on one row all the authors of abook? Thanks Antonio