[Zope] Select in ZSQL

[Aaron Williamson]

> 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

--Aaron