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

Reply via email to