On May 22, 2008, at 6:44 PM, Jeff Putsch wrote:
> > > On May 22, 2008, at 3:08 PM, Michael Bayer wrote: > >> a1.join(a2, <onclause>) should do it. if not, supply a full test >> case >> and a description of the specific problem. > > OK, I guess. we need more detail than "it fails" to have a clue what the issue might be is.... > So how do I see the SQL that gets generated? > > I've tried this: > > print select(from_obj=[a1.join(a2), a1.c.eid == a2.c.eid]) its not a pretty error message, but the main idea there is that "x==y" is not a FROM object. to join on an explciit ON clause, its like this: a1.join(a2, a1.c.eid==a2.c.eid) and the "print" will work there. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
