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.