[web2py] Re: Two LEFT JOINs and left=

[Annet]

I tried:

row=db().select(db.Organization.name,db.Hub.name,\
left=[db.Node.on(db.Node.id==db.Organization.nodeID),db.Node.on(db.Node.id==db.Hub.nodeID)]).first()

but that results in:

<class 'psycopg2.ProgrammingError'> invalid reference to FROM-clause entry 
for table "organization" LINE 1: ...OM Organization, Hub LEFT JOIN Node ON 
(Node.id = Organizati... ^ HINT: There is an entry for table 
"organization", but it cannot be referenced from this part of the query. 

Annet