[Zope] Request.py and duplicate column names

Brad Clements bkc@murkworks.com
Tue, 2 Mar 1999 11:05:41 -0400


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

What about

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


Wouldn't this give you vars called a.id and b.id?

Hmmm... I bet Zope won't like that.


Brad Clements,                bkc@murkworks.com   (315)268-1000
http://www.murkworks.com                          (315)268-9812 Fax
netmeeting: ils://ils.murkworks.com               ICQ: 14856937