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 <wtras...@googlemail.com> wrote:
> 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
