Hi,
I got the trick !!!!
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_group.id ==
db.auth_membership.user_id) ] )
Indeed, this the query I need!! And it works fine.
:-)
On Jan 10, 6:10 pm, Uolter <wtras...@googlemail.com> wrote:
> 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
>
>
