On Jul 23, 2009, at 8:43 PM, Gregg Lind wrote:
> > Hm. I appreciate the help, but something is clearly still failing > here. > >> session.query(Route,*sq.c).join(sq.c.max_hop) > ArgumentError: Can't find any foreign key relationships between > 'route' and 'max_hop' > > Maybe the filter based solution is just fine here :) that's not the call sig for query.join() . if youre dealing with SQL expression components, its join((selectable, onclause), ... ), so here join((sq, sq.c.max_hop==Route.hop)) . --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---