You want something along these lines:

<dtml-in selectFromTable1>
   <dtml-in expr="selectFromTable2(id=_['id'])">
      ....display record....
   </dtml-in>
</dtml-in>

This would be more efficient than pulling out the whole of two tables.

Chris

On Mon, 4 Dec 2000, Tom Deprez wrote:

> Hi,
> 
> I'm wondering how the following can be done.
> 
> I've 2 databases. I want to do a 'join' with 2 tables, both in a different
> database. 
> Is it possible to retrieve data of both tables with a ZSQLMethod and then
> do a programatically join? What's the easiest python way?
> 
> Thanks, Tom.
> 
> _______________________________________________
> Zope maillist  -  [EMAIL PROTECTED]
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
> 


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to