Thank you for the quick and very helpful response. I'm making progress again!
Jeff. On May 22, 2008, at 3:50 PM, Michael Bayer wrote: > > > 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 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 -~----------~----~----~----~------~----~------~--~---