Skip to content

Instantly share code, notes, and snippets.

@name1984

name1984/gist:bcdba9376a5f031c0ac1

Created January 15, 2015 15:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save name1984/bcdba9376a5f031c0ac1 to your computer and use it in GitHub Desktop.
Save name1984/bcdba9376a5f031c0ac1 to your computer and use it in GitHub Desktop.
Download ZIP
Select Vista
Raw
gistfile1.sql
select
prison_person.id, prison_person.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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment