If it helps, here is how I can get the desired result in raw SQL: SELECT * FROM benchmark_targets t2 LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC)t1 ON t2.KPID = t1.KPID;
Now how to do it in DAL? -- --- 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.