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

alan runyan alan runyan" <runyaga@runyaga.com
Wed, 24 Apr 2002 11:11:10 -0500


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