[Zope] how to join two table?

[Michel Pelletier]

> -----Original Message-----
> From: Rod Za [mailto:rodza@bhnet.com.br]
> Sent: Monday, November 22, 1999 9:45 AM
> To: Jim Sanford; zope@zope.org
> 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
> 
> i try to do that but dont work, very well, i am working with 
> .DBF files.
> need i use index? (if i need, how to do?)

This is getting a little off topic, sounds like an SQL thread to me.
Perhaps there is another list you could move this to?

-Michel