Hi
New to web2py and DAL and some things are just not obvious, probably
because I'm coming from SQLObject where things are done a bit
differently. Here is my challenge, probably something everyone else
here has already dealt with:
Using the following auth tables:
auth_user
auth_group
auth_membership
...how do I get a list of users who are members of a specific group?
Simple SQL would be:
SELECT first_name, last_name
FROM auth_user
WHERE id IN (SELECT user_id FROM auth_membership WHERE group_id = 4)
How would I do this most efficiently using the DAL?
-Jim