Also, can you try: row=db().select(db.Organization.name <http://db.organization.name/>, db.Hub.name <http://db.hub.name/>,\ left=[db.Organization.on(db.Node.id <http://db.node.id/>== db.Organization.nodeID),db.Hub.on(db.Node.id <http://db.node.id/>==db.Hub. nodeID)]).first()
Marin On Wed, May 16, 2012 at 11:22 AM, Marin Pranjić <marin.pran...@gmail.com>wrote: > 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 >> > >
