this example lacks "consistency", and engines that are forgiving about SQL standards such as mysql and sqlite just make everything worse. Grouping in sql means what it means in english: you take a "universe" of n records and you'd like represent it in groups . Grouping doesn't "change" the "universe". That's why compliant engines (such as postgresql) allow in the selected fields of a group(ed) query to be either the group(ed) fields or aggregates of the remaining fields (such as sum(), avg(), min(), etc). Could you post an example with data that you have in the tables and what data do you want back ?
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
