I used the syntax that you gave me but it returned 2 records instead of 1. Is there something that I am missing ? the following is the syntax I used
"SELECT * FROM CIVIL JOIN persons ON persons.pkeyident = civil.keyident AND (persons.per_type = 'D' or persons.per_type = 'C')"

Thanks Again !
Stephen J. Hunt