On Tuesday, April 2, 2019 at 5:09:56 PM UTC-7, João Matos wrote:
> [complex scenario] > Any ideas? > Since my level of knowledge would give one of sums or rows, but not both, I'm hoping the regulars chip in. I have a small amount of experience with subselects in the SQLite command line (small amount == rote copy of an example from the web), but I haven't tried to do that from within a controller yet. This SO q-and-a is the sort of thing I got my experience with, the top answer (as shown to me) by yunzen is a subselect example. <URL:https://stackoverflow.com/questions/12927268/sum-of-grouped-count-in-sql-query> there are also examples on the page using UNION. I will be interested myself in hearing these translated to DALek (sorry, bad humor),. /dps > -- 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/d/optout.
