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)

Reply via email to