[Zope-DB] HowTo access query fields of multiple tables?

[alan runyan]

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