view sgp

ppls_loc.sql

create or replace view ppl_ubicacion as
select 
  prison_person.id, prison_person.name as ppl_name, prison_person.last_name, prison_person.location_id, 
  prison_location.name, (select prison_location.name FROM prison_location WHERE id=prison_person.etapa_id) as etapa_name, 
  (SELECT prison_location.name FROM prison_location WHERE id=prison_person.pabellon_id) as pabellon_name, 
  prison_person.etapa_id, prison_person.pabellon_id 
from 
  prison_person 
join 
  prison_location 
on 
  prison_person.location_id=prison_location.id where prison_person.state in ('preso','sentenciado','procesado');