Forgot the WHERE in my SQL statement. Should be: 

SELECT * FROM benchmark_targets t2 
LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime 
DESC)t1 ON t2.KPID = t1.KPID 
WHERE t2.benchmark = 10;

-- 

--- 
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.


Reply via email to