[Zope] Select in ZSQL

[Diego Rodrigo Neufert]

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 Rodrigo Neufert
-webmaster
---------------------------
(Magic Web Design)
(email) (diego@magicwebdesign.com.br)
(curitiba) (pr)