[Zope] duplicate column name

[Stephane Bortzmeyer]

On Thursday 7 December 2000, at 13 h 15, the keyboard of Olaf Zanger 
<olaf.zanger@soli-con.com> wrote:

> -> select adr.id,fac.id from fac, adr

It is legal SQL but
 
> ->error type: value error
> ->error value: duplicate column name,id

I believe Zope (not PostgreSQL) needs different names for columns. Otherwise, how would it choose the name of DTML variables? Try renaming the columns with AS in the ZSQL method.