Hi DenesL, thank you very much for your feedback.
I gave it a go, but I'm still getting doubled records. User John appears twice even if in the auth_user table he is alone. Uolter On Jan 6, 3:30 pm, DenesL <denes1...@yahoo.ca> wrote: > Just make a list of theleftjoins: > > 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.on(db.auth_user.id == > db.auth_membership.user_id) ] ) > > On Jan 6, 5:25 am, Uolter <wtras...@googlemail.com> wrote: > > > Hi all, > > > I have this sql query that combine twoleftouterjoin. > > > select * from auth_user > > LEFTOUTERJOINauth_membership on > > auth_membership.user_id=auth_user.id > > LEFTOUTERJOINauth_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 > >
