Another thing that would work: <dtml-in selectFromTable1> <dtml-in expr="selectFromTable2(id=_['id'])"> ....display record.... </dtml-in> </dtml-in> Chris On Wed, 22 Nov 2000, Phil Harris wrote:
Link the SQL table into Access and then use both from Zodbcda connected to Access.
hth
Phil ----- Original Message ----- From: "Capesius, Alan" <CapesiusA@Sysmex.com> To: <zope@zope.org> Sent: Wednesday, November 22, 2000 3:56 PM Subject: [Zope] Multiple ZODBC sources
I need to join tables from two ODBC sources, one MS Access one SQL.
ZODBC DA seems to be limited to one data source at a time. Is there any way to join tables from two different sources?
Alan Capesius, MCSE+20 Technical Support Engineer Sysmex Corporation of America capesiusa@sysmex.com
_______________________________________________ Zope maillist - Zope@zope.org 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 - Zope@zope.org 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 )