27 Apr
2004
27 Apr
'04
10:24 a.m.
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