here is my code: c_table = Table('campaign', metadata, Column('id', Integer, primary_key=True), Column('content', Unicode(200)), )
m_table = Table('mailings', metadata, Column('id', Integer, primary_key=True), Column('campaign_id',Integer, ForeignKey('campaign.id')), Column('date', DateTime), ) class Mailing(object): pass class Campaign(object): pass mapper(Campaign, c_table) mapper(Mailing, m_table, properties={'published_campaign':relation(Campaign, uselist=False) }) my question is this, when I do the following: mailing = session.query(Mailing).options(eagerload('published_campaign')).get(1) the resulting query does an outer join. How can I have it do a regular join? thanks, Matt --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---