Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- ministerio.nombre AS MINISTERIO ,
- subsecretaria.nombre AS SUBSECRETARIA,
- institucion.nombre AS INSTITUCION,
- institucion.id AS INSTITUCION_ID,
- entidad.nombre AS ENTIDAD,
- entidad.id AS ENTIDAD_ID
- FROM public.institucion
- INNER JOIN public.subsecretaria ON (institucion.subsecretaria_id = subsecretaria.id)
- INNER JOIN public.ministerio ON ( institucion.ministerio_id = ministerio.id)
- LEFT JOIN public.entidad ON (entidad.institucion_id = institucion.id)
- WHERE UPPER(institucion.nombre) LIKE UPPER('%NOMBRE%');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement