From: Claudio Nanni
Date: May 19 2011 9:42am
Subject: Re: Complex Query
List-Archive: http://lists.mysql.com/mysql/225034
Message-Id: <BANLkTim5=MakDqVsPE_xOY644GCeRDyvow@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf3054ab590cbca004a39dd3f0

--20cf3054ab590cbca004a39dd3f0
Content-Type: text/plain; charset=ISO-8859-1

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

--20cf3054ab590cbca004a39dd3f0--