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 |[EMAIL PROTECTED]|
>
> _______________________________________________
> 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 )