Re: MYSQL Relation n-m

2002-06-06 Thread tonibern
> >>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 >

MYSQL Relation n-m

2002-06-06 Thread tonibern
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 > > > > -