1

sql aggregate functions

view story
linux-howto

http://ubuntuforums.org – I am having trouble when it comes to writing queries that involve aggregate functions (such as Count and also when using Having). I have two tables of People (id and name) and Books (bookid, author_id, title) (here author_id is a foreign key to People id). I currently have a query that returns to me all the People who have written a book (not all the people have written a book). Code: SELECT People.name, Books.title FROM People, Books WHERE Books.author_id = People.id; Now I am trying to find only People who have written more than 2 books and have it select the same info (people.name an (Hardware)