show_discrepancies.sql
393 Bytes
-- 10 Registros de la Cartografía Local (SNC)
SELECT 'LOCAL_SNC' as fuente, ccatastral, snc_cuenta, ccc
FROM public.e505_lotes_activos
LIMIT 10;
-- 10 Registros del Sistema Municipal (SIGEM)
SELECT 'REMOTO_SIGEM' as fuente, inm_ctacatastral, REPLACE(inm_ctacatastral, '-', '') as join_esperado, trb_total_deuda
FROM fdw_505.v_liq_entidad_totalxobjeto
WHERE trb_total_deuda > 0
LIMIT 10;