[Zope] something wrong with ZSQL

[Samuele Giovanni Tonon]

>> select
>>     table1.name as table1_name,
>>     table1.lastname as table1_lastname,
>>     table2.name as table2_name,
>>     table2.lastname as table2_lastname
>> from table1, table2
>> where table1.cod = table2.cod
> 
> yes you're right,
> but this is a solution using alias,
> i think zope should handle itself this situation,
> as far as i can remember, even php can handle this problem..

uhm, i discovered it's a problem related to ZSQL and not (as i first 
thought) to ZPT.

thanks to all for the help, i'll use alias (hope one day ZSQL will solve
this problem).

Regards
Samuele