[Zope] how to join two table?

Rod Za rodza@bhnet.com.br
Mon, 22 Nov 1999 03:09:01 -0200


Thank you very much, Jim!

Rod Za

----- Original Message -----
From: Jim Sanford <jsanford@atinucleus.com>
To: Rod Za <rodza@bhnet.com.br>; <zope@zope.org>
Sent: Monday, November 22, 1999 2:18 AM
Subject: Re: [Zope] how to join two table?


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