Create your sql statement to return the data from the 2 tables in one row joining the 2 tables on a uniquekey that is common to both tables.
select table1.col1, table1.col2, table2.col3, table2.col6 from table1 join table2 on table1.<uniquekey> = table2.<uniquekey> hth, Mike On Fri, 2003-07-04 at 10:57, Exteam wrote: > Hi, > we are having a problem while presentation of values retreived from > multi tables(from mysql) in ZPT we use zsql to retreive from each > individual table. But while presentation part comes, we are unable to > position the values from multi table in a single row . > As it is apparant that a tr can repeat only a single table at a time > by the tal functions. > > what we had tried is > <tr repeat='item python:container.zsqlmethodname() > > We want the Zpt to repeat more than one table in a single row. > So that we could retreive the requisite values from the tables and > present it. > > How can it be resolved. > Thanks > exteam > > > Yahoo! India Mobile SMS using the Yahoo! Messenger; Download latest > version. _______________________________________________ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )