Also, for more about 'belongs' and nested selects, see http://web2py.com/book/default/chapter/06#belongs. Anthony
On Wednesday, June 15, 2011 4:00:34 PM UTC-4, elffikk wrote: > not tested: > your sql query equivalent > > group_query = > db(db.auth_membership.group_id==4)._select(db.auth_membership.user_id) > rows = > db(db.auth_user.id.belongs(group_query)).select(db.auth_user.first_name,db.auth_user.last_name) >
