On Fri, Jun 22, 2007 at 08:30:07PM -0000, Michael Bayer wrote: > the contents of the columns clause is configurable via the select() > construct directly: > > result=select([records_a, records_ptr], > records_a.c.type=='A', > from_obj=[model.outerjoin(records_a, records_ptr, > ( (records_a.c.inet==records_ptr.c.inet) & > (records_ptr.c.type=='PTR') ))], > use_labels=True).execute().fetchone()
Very good. That does what I wanted. A full outer join would be perfect but I'm willing to UNION my way through. :) Thank you. Christoph --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
