Untitled

-- CRUCE DE SAS con CLIENTE_PERSONA
SELECT T.codexterno,P.CONSENTIDATOSPER
FROM `rs-nprd-dlk-data-rwz-51a6.bdsas__app_iaa_tercero.TER_TERCERO` T
				  INNER JOIN `rs-nprd-dlk-data-rwz-51a6.bdsas__app_iaa_tercero.TER_PERSONA` P
				  ON T.IDETERCERO = P.IDETERCERO
					AND T.USUMODIF <> 'PWEB' 

INNER JOIN --cruce con clientes
				  (SELECT tip_documento,num_documento,cod_acselx, COALESCE(des_segmentacion_growth,'NULL') as des_segmentacion_growth, case when DATETIME_ADD(fec_nacimiento,INTERVAL 18 YEAR) <= "2023-04-01" THEN "SI" ELSE "NO" END as ind_mayor_edad
				  from `rs-nprd-dlk-dd-az-d8bc.anl_persona.cliente_persona`
				  where DATE(PERIODO) = "2023-04-01") as CLIE
 ON T.codexterno = CAST(CLIE.cod_acselx AS INT64)

limit 10
;

-- CRUCE DE SAS con CLIENTE_PERSONA_DETALLE
SELECT T.codexterno,P.CONSENTIDATOSPER
FROM `rs-nprd-dlk-data-rwz-51a6.bdsas__app_iaa_tercero.TER_TERCERO` T
				  INNER JOIN `rs-nprd-dlk-data-rwz-51a6.bdsas__app_iaa_tercero.TER_PERSONA` P
				  ON T.IDETERCERO = P.IDETERCERO
					AND T.USUMODIF <> 'PWEB' 

INNER JOIN --cruce con clientes
				  (SELECT id_cliente_persona,pol_des_canal
				  from `rs-nprd-dlk-dd-az-d8bc.anl_persona.cliente_persona_detalle`
				  where DATE(PERIODO) = "2023-04-01") as CLIE_DETALLE
 ON cast(T.codexterno as string) = SPLIT(CLIE_DETALLE.id_cliente_persona,'-')[OFFSET(1)]

 ;