Untitled

select * FROM
(
  select 
  RS1.Nombres as RS1_nombre,
  PDR.nombres as pdr_nombre,
  RS1.ApePaterno as RS1_ApePaterno,
  PDR.apell_pat as pdr_ApePaterno,
  RS1.ApeMaterno as RS1_ApeMaterno,
  PDR.apell_mat as pdr_ApeMaterno,
  case WHEN TRIM(RS1.Nombres) = TRIM(PDR.nombres) THEN true ELSE false end as simil_nombre,
  case WHEN TRIM(RS1.ApePaterno) = TRIM(PDR.apell_pat) THEN true ELSE false end as simil_apell_pat,
  case WHEN TRIM(RS1.ApeMaterno) = TRIM(PDR.apell_mat) THEN true ELSE false end as simil_apell_mat,
  from
    `rs-nprd-dlk-dt-trsv-digt-f7ef.trsv_procesos_calidad.RS1_carga_por_validar` RS1


  inner join
   (SELECT DNI, tipo_documento,NOMBRES, apell_pat, apell_mat FROM `rs-prd-dlk-dd-rawzone-a40f.ext__padron.persona_padron_electoral`
						WHERE PERIODO = (SELECT MAX(PERIODO) FROM `rs-prd-dlk-dd-rawzone-a40f.ext__padron.persona_padron_electoral`)) AS PDR

    ON RS1.nro_corregido  = PDR.dni
    AND ((RS1.TipoIdDoc = "2" AND PDR.tipo_documento = 1) OR (RS1.TipoIdDoc = "4" AND PDR.tipo_documento = 3))
)
WHERE  simil_nombre is false OR simil_apell_pat is false OR simil_apell_mat is FALSE