I wrote a query like: SELECT tableA.name, tableB.name FROM tableA, tableB WHERE ... You cant do this. This is SQL problem not a ZOPE problem. You need to use aliases. "Select tableA.name as name1, tableB.name as name2 from tableA, tableB Where.." <dtml-in myquery> <dtml-var name1> <dtml-var name2> </dtml-in> ~runyaga