Re: Complex Query

[(Hal]

>>>> 2011/05/18 22:22 +0100, Mimi Cafe >>>>
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;
<<<<<<<<
You are looking for grouping (aggregating) functions. But how do your tables look? and at
first you mention two tables, but your query has three.