[Zope] something wrong with ZSQL

[Samuele Giovanni Tonon]

Jaroslav Lukesh wrote:
> Samuele Giovanni Tonon wrote:
> 
>> hi to all,
>>
>> supposes you have a ZSQL method of this kind
>>
>> select  table1.name, table1.lastname, table2.name, table2.lastname
>> from table1, table2
>> where table1.cod = table2.cod
> 
> 
> You need to use this:
> 
> 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..

Regards
Samuele