from the documentation shouldn't this work? join(table1, table2).select().execute().fetchall()
When I jun that code I get the error None.table1 not defined however if I run join(table1, table2, table1.c.id==table2.c.fk).select().execute().fetchall() Then I get the expected results. shouldn't the above code work if I've defined the foreign key relationship correctly? jose ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users