Re: [web2py] Re: Two LEFT JOINs and left=

Johann and Marin, Thanks for your replies. Also, can you try: > > row=db().select(db.Organization.name , > db.Hub.name ,\ > left=[db.Organization.on(db.Node.id == > db.Organization.nodeID),db.Hub.on(db.Node.id

Re: [web2py] Re: Two LEFT JOINs and left=

Also, can you try: row=db().select(db.Organization.name , db.Hub.name ,\ left=[db.Organization.on(db.Node.id == db.Organization.nodeID),db.Hub.on(db.Node.id ==db.Hub. nodeID)]).first() Marin On Wed, May 16

Re: [web2py] Re: Two LEFT JOINs and left=

Can you post entire query generated using _select method? On Wed, May 16, 2012 at 10:51 AM, Annet wrote: > 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 result

Re: [web2py] Re: Two LEFT JOINs and left=

On 16 May 2012 10:51, Annet wrote: > 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: > > invalid reference to FROM-clause entry > for table "organiza

[web2py] Re: Two LEFT JOINs and left=

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: invalid reference to FROM-clause entry for table "organization" LINE 1: ...OM Organization, Hub LEFT JOIN Node O