Oops! The a.b_id=a.id was a typo in my mail. Sorry about that. I did mean a.b_id=b.id. I also tried out Brad Clements' suggestion (thanks, I would have never thought to write it that way!) but it raises the same exception. It works fine with the patch, though. Thank you for your responses! John Jarvis Tokyo Electron FE, Ltd.

-----Original Message----- From: chris.hunter@humancode.com [SMTP:chris.hunter@humancode.com] Sent: Wednesday, March 03, 1999 1:46 AM To: bkc@murkworks.com Cc: TFE MMS JARVIS JOHN; zope@zope.org Subject: Re: [Zope] Request.py and duplicate column names

Brad Clements wrote:

...

On 2 Mar 99, at 18:40, TFE MMS JARVIS JOHN wrote:

...

1. When trying to do a join (a lazy query, I know) like:

select a.*, b.* from tablea a, tableb b where a.b_id=a.id

Is there any chance that you're trying to do something like:

select * from a, b where a.b_id = b.id ^ Note that I'm joining a field in a to a field in b here (not 2 fields in a)

Hope this helps.

--chris

_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope