Re: [Zope] Select in ZSQL

> I'm having problems with this select statement in ZQL using a MySQL db: > select table1.id, table2.id from table_x table1, table_y table2 > > I got this error: > Error, exceptions.ValueError: Duplicate column name, id Try: select table1.id, table2 AS id2 from table_x table1, table_y table2 --

Re: [Zope] Select in ZSQL

Diego Rodrigo Neufert wrote: > > Hi... > > I'm having problems with this select statement in ZQL using a MySQL db: > select table1.id, table2.id from table_x table1, table_y table2 > > I got this error: > Error, exceptions.ValueError: Duplicate column name, id Because you *have* identical (dup

[Zope] Select in ZSQL

Hi... I'm having problems with this select statement in ZQL using a MySQL db: select table1.id, table2.id from table_x table1, table_y table2 I got this error: Error, exceptions.ValueError: Duplicate column name, id Anyone know how to get this working? -- --- Diego Rod