sorry, should have been:
db().select(db.dog.name, father.name, mother.name,
left=(father.on(father.id==db.dog.father_id),
mother.on(mother.id==db.dog.mother_id)))
On Jun 9, 3:03 am, Peter Etchells <[email protected]> wrote:
> prints:
> SELECT dog.name, dog.name, dog.name FROM LEFT JOIN dog ON
> dog.id=dog.father_id LEFT JOIN dog ON dog.id=dog.mother_id;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---