URGENT RE: [Zope] ZmysqlDA

[Chris McDonough]

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 )