Thank you, Richard and James. 2013/6/14 James K. Lowden <jklow...@schemamania.org> > > > Why not simply > > SELECT f.name, count(e.food_id) as 'episodes' > FROM foods as f > OUTER > JOIN foods_episodes as e > ON f.id = e.food_id > GROUP BY f.name > ORDER BY episodes DESC LIMIT 10; > > In my opinion, That example is used in beginning of SQL chapter, therefore, JOIN and GROUP BY is not explained yet.
Regards, Yongil. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
