Complex Query

[Mimi Cafe]

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