This syntaxt is perfetly ok: select * from table1 left join table2 on table1.postal_id=table2.postal_id http://www.mysql.com/doc/J/O/JOIN.html 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://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )