I'm only talking to myself here, but the notes are helpful...
This is how I get the desired result in web2py using the executesql command:
foo = db.executesql('SELECT * FROM benchmark_targets AS t2 LEFT JOIN
(SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC) AS t1 ON
t2.KPID = t1.KPID WHERE t2.benchmark = ' + str(request.args(1)))
Now if only someone could guide me to doing it the web2py way!
--
---
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/groups/opt_out.
