im not sure if full outer join is really available on most databases. On Jun 23, 5:12 am, Christoph Haas <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
