Hello Michael, many thanks for answer. The tables are inputted automatically by SQLAlchemy. Because of this I thought there should not be confusion over schema names.
Well, I could solve the problem by following code: --------------------------------------- @mapper_property('hapo.common.countries.Country',secondary_table='cou2ent') def citizens(self, mapper, cou_mapper, metadata, username, cou2ent): return sqlalchemy.orm.relation( cou_mapper, uselist=True, secondary= cou2ent, primaryjoin=mapper.local_table.c.ent_id==cou2ent.c.ent_key, secondaryjoin=cou2ent.c.cou_key==cou_mapper.local_table.c.cou_iso2, foreign_keys = [cou2ent.c.cou_key, cou2ent.c.ent_key] ) --------------------------------------- Thank you very much indeed. Kai --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---