I wonder if something like this would work: <dtml-in selectFromTable1> <dtml-in selectFromTable2> <dtml-if idFromTable1 = idFromTable2> ....display parts of the two records.... </dtml-if> </dtml-in> </dtml-in> Might be more efficient to make one of the dtml-ins a dtml-with and find the item with the matching id. Interesting problem, I wish I had some time to play around with it. Chris On Thu, 23 Nov 2000, Andrew Kenneth Milton wrote:

+-------[ Capesius, Alan ]---------------------- | 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?

Write a method to copy the results from Access into a temporary table of the other.

Then do your query and clean up.

-- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|

_______________________________________________ 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 )

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 )