[Zope] Request.py and duplicate column names

Chris Hunter chris.hunter@humancode.com
Tue, 02 Mar 1999 10:45:56 -0600


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