You do this with the SELECT statement in the database query, not with Zope or ZSQL per se. ZSQL just sends the SELECT statement to the database. Tom Passin >From: Rod Za <rodza@bhnet.com.br> >How i can join two table with ZSQL? > >thank you. > >Rod Za