This is *not* the case. The query returns a perfect result in mysql. http://www.mysql.com/doc/J/O/JOIN.html \Oliver
-----Original Message----- From: Chris McDonough [mailto:chrism@zope.com] Sent: 29. maj 2002 19:38 To: Oliver Marx Cc: Zope@Zope. Org Subject: Re: URGENT RE: [Zope] ZmysqlDA
This has nothing to do with Zope other than the fact that you're carrying out a SQL query via a ZSQL method. This error message comes from MySQL. Apparently there's a problem with your syntax. Maybe MySQL doesn't support this statement?
- C
On Wed, 2002-05-29 at 13:34, Oliver Marx wrote:
How do you guys/girls do joins? Am I missing something about Zope?
\Oliver
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of 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 )
_______________________________________________ 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 )