peek_success_matches.sql 333 Bytes

Edit Raw Blame History

-- Casos donde el JOIN del usuario SI funciona
SELECT
    lot.snc_cuenta,
    liq.inm_ctacatastral,
    REPLACE(liq.inm_ctacatastral, '-', '') as match_db,
    lot.mz,
    lot.lote
FROM public.e505_lotes_activos lot
JOIN fdw_505.v_liq_entidad_totalxobjeto liq ON lot.snc_cuenta = REPLACE(liq.inm_ctacatastral, '-', '')
LIMIT 5;