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