> 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