zipcode_meta_join_subquery = session.query(us_zipcode_table.c.city_id, us_zipcode_table.c.zipcode_population, us_zipcode_table.c.average_house_value).group_by(us_zipc ode_table.c.city_id).subquery()
mapper(USCity, us_city_table, properties={ 'state':relation(USState, backref=backref('cities')), 'zipcode_meta':relation(USZipCode, primaryjoin= (zipcode_meta_join_subquery, zipcode_meta_join_subquery.c.city_id==us_city_table.c.city_id)) }) The above code obviously doesn't work. How do I add a join to the above subquery in my mapper? --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---