Have you tried select table1.postal_id as id1, table2.postal_id as id2 ...... 



then Zope sees them as id1 and id2, I think



Nitin Borwankar



Oliver Marx wrote:



  
This syntaxt is perfetly ok:

select * from table1 left join table2 on table1.postal_id=table2.postal_id



Id is reserved in Zope, so I altered the tables.

But Zope (ZmysqlDA) is still complaining about duplicate column names.


\Oliver


  

    

      
-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
Dennis Allison
Sent: 29. maj 2002 19:52
To: Oliver Marx
Cc: Zope@Zope. Org
Subject: Re: URGENT RE: [Zope] ZmysqlDA



Oliver,
Check your MySQL documentation and the version of your running 
MySQL.  The Zope DB connection products simply pass the SQL query 
on to the database management system and report what errors it 
finds....




On Wed, 29 May 2002, Oliver Marx wrote:


      

        
How do you guys/girls do joins?
Am I missing something about Zope?

\Oliver


        

          

            
Oliver Marx
Sent: 29. maj 2002 19:18
To: Zope@Zope. Org
Subject: [Zope] ZmysqlDA

select * from table1 left join table2 on table1.id=table2.id 

Error:
duplicate column name, id

Is this an error or a feature?

\Oliver

            

            

            

            


_______________________________________________
Zope maillist  -  Zope@zope.org
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev )

            

            

            


_______________________________________________
Zope maillist  -  Zope@zope.org
http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce
 http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev )