Hi all, I have this sql query that combine two left outer join.
select * from auth_user LEFT OUTER JOIN auth_membership on auth_membership.user_id=auth_user.id LEFT OUTER JOIN auth_group on auth_membership.user_id=auth_user.id basically, it returns all users with their role when they have a role or not. It works fine in sqlite and I wonder how run it in Web2py? I'm trying something like this, but it doesn't work as expected: users=db().select(db.auth_user.ALL, db.auth_group.ALL, left=db.auth_membership.on(db.auth_user.id == db.auth_membership.user_id & db.auth_group.id == db.auth_membership.group_id)) Need some help!!! Thanks in advance Uolter twitter:@uollter linkedin: http://it.linkedin.com/in/wtraspad