Sql Sentencia

[[Ivanzinho]]

Prueba con :

Código SQL [-]
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' )        
      and matrix_odontograma.cedula in (select cedula, count(cedula) as cont 
                                        from matrix_odontograma                                          
                                        group by cedula having cont = 3)
group by cedula 
having count(matrix_odontograma.cedula) between 3 and 3