Hello Here's my thing:
I have two DB tables, refugees and offices, which are independent tables (no foreign key). I already have two mappers for those tables: mapper(Refugee, refugees_table) mapper(Office, offices_table) In addition to being able to do independent queries on each table, I'd like to do queries in both tables (UNION) and get results in objects of type Location (a Python class of my own). In other words, I'd like to do queries using session.query(Location). I've tried various things (Mapping a Class against Multiple Tables in the doc in particular), but with no luck. Does anyone have suggestions? Thanks a lot, -- Eric --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---