> Ok...I had read a message that mentioned the aggregate > function requirement...but how would I write my example > query to include an (unneeded?) aggregate function? > > (And why would there be an aggregate requirement anyway?) > > Query (MySQL version): > > Select * from books group by genre
The GROUP BY clause requires an aggregate because its sole purpose is to let you perform aggregations on subsets of data returned by your query, instead of on the entire set. I don't use MySQL very much, but I can't even imagine what your example query would return, since there is no aggregation upon which to group. How, in your example, does the query differ from one with no GROUP BY clause? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243379 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
