>>>> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org