>
> SELECT *
> FROM
> OnResource
> LEFT JOIN Contact Owner ON Owner.id = OnResource.Contact
> LEFT JOIN Contact Proxy ON Proxy.id = OnResource.Proxy
> ORDER BY
> Owner.LastName, Owner.FirstName
>
> I tried this DAL select syntax
>
> timesheet_owners = db().select(db.OnResource.ALL,
> db.Contact.with_alias('Owner').ALL,
> db.Contact.with_alias('Proxy').ALL,
> left=[db.Contact.with_alias('Owner').on(db.Contact.id ==
> db.OnResource.Contact),
> db.Contact.with_alias('Proxy').on(db.Contact.id ==
> db.OnResource.Proxy)],
>
Looks like the cross join might be a separate issue. But regarding the left
joins, if using aliases, you will have to manually write the SQL for the
"ON" clause rather than using DAL syntax:
db.Contact.with_alias('Owner').on('Owner.id <http://db.contact.id/> =
OnResource.Contact')
Anthony
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
