[Zope] how to join two table?

Rod Za rodza@bhnet.com.br
Mon, 22 Nov 1999 12:44:40 -0200


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

Thank you

Rod Za