[web2py] Re: Combining left outer join how to?

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

[web2py] Re: Combining left outer join how to?

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 wrote: > Just make a list of theleftjoins: > > users=db().select(db.auth_user.ALL, > d

[web2py] Re: Combining left outer join how to?

Just make a list of the left joins: 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 wrote: > Hi all, > > I h