Re: Complex Query

[Claudio Nanni]

Hint:

   - group_concat
   - group by
   - having count(*)>1

Cheers

Claudio


2011/5/18 Mimi Cafe <mimicafe@stripped>

> 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
>



-- 
Claudio