I'm guessing it will be hard. You'll better code a view and access it as a "fake table".
PS: you show it in a grid.... then what record do you want to add/edit/delete ? I'm guessing that this time you want to use the grid just to search, orderby and paginate, but there's a LOT of logic inside it for more things that needs to be considered. On Thursday, April 4, 2013 12:23:58 PM UTC+2, Johann Spies wrote: > > How would I be able to use a query like this (or the DAL equivalent) to > show the result in a grid? > > select so as Journal, SUM(aantal) as Articles > from isi.nr_arts_per_journal > group by Journal > order by Journal > > Regars > Johann > > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3) > -- --- 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.