I've made some experiments with "groupby" but every time it has reduced the selection to one 'city' and one 'institution'. The other 'institutions' belonging to the 'city' are omitted. The same situation is when using pure SQL query via database browser so it is a matter of the functionality of SQL. Maybe I'm missing something but I not able to get more then one record using "GROUP BY". Przemek
-- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
