[Zope] how to join two table?

[Jim Sanford]

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 )
>
>