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