>Sorry !
>1. persons.per_type = 'D' and persons.keyident=civil.keyident
>2. persons.per_type = 'C' and persons.keyident=civil.keyident
That's two records but you said that you want only one record in the result. Which one you want to include in the result?
--sb--