i played a bit with your thing... how do u expect the id column to appear in the Employee actualy? do u expect to get the base person' one, or the child one? or both? looking from the child, yes, the child one will obscure the parent one, but from the parent.. u'll never get the child one.
i added this after query=...: $> for r in query.select(): print r.id, r.salary, r.name, r.person_id 1 250 alice 1 2 200 bob 2 do u see that .id and person_id become same? some more: $> for c in empl_mapper.props['id'].columns: $> print c persons.id employees.id so the 'id' column maps to 2 columns, and the one that the mapper is using (i guess the first) is the person.id. u have to do it in some another way, try renaming one of the columns to something else. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---