A last question, is there a way to define the join in the Section mapper so that it would be possible to get a section's keywords by just doing section.keywords?
mapper(Item, item_table, properties = {'keywords': relation(Keyword, secondary=itemkeyword_table, backref='items')}) mapper(Keyword, keyword_table) mapper(Section, section_table, properties = {'items': relation(Item, backref='section'), 'keywords':relation(?express the join here)}) Thanks. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users