Select Tbl1.Cedula
From
(SELECT CEDULA, COUNT(CEDULA) AS CONT
FROM MATRIX_ODONTOGRAMA
GROUP BY CEDULA HAVING CONT = 3) as Tbl1
Join
(SELECT matrix_odontograma.cedula as Cedula, primer_nombre as Nombre,
primer_apellido as Apellido, genero as Genero,
fecha_nacimiento as FechaNacimiento
FROM matrix_odontograma, pacientes
where (matrix_odontograma.cedula = pacientes.cedula) AND
(idDientes = 1 AND Superficie = 1 AND nombre_enfermedad = 'Caries'
or idDientes = 2 AND Superficie = 6 AND nombre_enfermedad = 'PPR'
or idDientes = 3 AND Superficie = 6 AND nombre_enfermedad = 'Extraido' )
group by cedula
having count(matrix_odontograma.cedula) between 3 and 3) as tbl2
on tbl1.Cedula = tbl2.Cedula