select a.keyfield, a.some_field, b.keyfield, b.another_field from table1 a, table2 b where b.keyfield=a.keyfield and a.some_field='some_stuff' order by b.another_field __________________________________________________________________ Jim Sanford . Database Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Source Code, No Royalties, Any CPU...It just make sense ! __________________________________________________________________ ----- Original Message ----- From: Rod Za <rodza@bhnet.com.br> To: <zope@zope.org> Sent: Sunday, November 21, 1999 8:19 PM Subject: [Zope] how to join two table?
How i can join two table with ZSQL?
thank you.
Rod Za
_______________________________________________ Zope maillist - Zope@zope.org 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 )