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