check out the examples for mapping to multiple tables at: http://docs.sqlalchemy.org/en/rel_0_7/orm/mapper_config.html#mapping-a-class-against-multiple-tables
also if you wanted to make a class hierarchy of Table3(Table2), Table2(Table1), straight joined inheritance can work: http://docs.sqlalchemy.org/en/rel_0_7/orm/inheritance.html#joined-table-inheritance On Apr 27, 2012, at 9:57 AM, Matteo Boscolo wrote: > Hi All, > In my db structure I have 3 tables each of this table extends the fields like > this : > > table_1 > id > name > > table_2 > id > surname > > table_3 > id > address > > the tree tables works like one > > table_sum > id > name > surname > address > > what I need is an object that give me all the fields like in example below.. > > class table_sum(Base,table_1,table_2,table_3): > __tablename__='table_sum' > > any idea in how to do it or what is the best way to manage this structure ? > regards, > Matteo > > > > > > > -- > 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. > -- 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.