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

maverick121@gmx.de maverick121@gmx.de
Tue, 23 Apr 2002 19:55:27 +0200 (MEST)

 I wrote a query like:
 SELECT tableA.name, tableB.name
 FROM tableA, tableB 
 WHERE ...
The query works well in the ZSQL test view. 
But how can I access the content of the .name fields in a dtml-var tag?
I tried it with:
 <dtml-in myquery>
   <dtml-var tableA.name>
   <dtml-var tableB.name>
 ... this doesn't work.
 I also tried renaming the fields in SQL:

 SELECT tableA.name AS Aname, tableB.name AS BName
 FROM tableA, tableB 
 WHERE ...
 <dtml-in myquery>
   <dtml-var Aname>
   <dtml-var Bname>

 but this also results in an error.
 I guess this is a FAQ, but I couldn't find the answer...
 Thanks in advance.

GMX - Die Kommunikationsplattform im Internet.