[Zope-DB] Combining 2 tables

Charlie Clark charlie at begeistert.org
Tue Aug 5 11:45:43 EDT 2003


On 2003-08-05 at 04:55:03 [+0200], Chan YH wrote:
> I would like to combine 2 sql tables into one using dtml/python script 
> method.
> Person (table) + Company (table) => Contact (table)
> 
> Can some give a me a tip?

You can do this directly in SQL, you don't need any DTML at all. However, 
how do you know if the person matches the company?

Charlie



More information about the Zope-DB mailing list