Hi I am trying to retrieve record from 2 tables (book and author), but my problem is how to retrieve all the names of authors where more than one author wrote a book.
Here is what i have: it works OK, except that it returns more than one row for books that have more than one author. select concat(fname,' ',initial,' ',lname) from author inner join book_author on fkauthor_id = pkauthor_id inner join book on fkisbn = pkisbn; Any idea who can formulate my query to retrieve the books with with names of all the authors concatenated in one? Mimi
