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 )