Skip to content

Instantly share code, notes, and snippets.

@glarrain

glarrain/MySQL-Chile:regiones-provincias-comunas

Forked from juque/MySQL-Chile:regiones-provincias-comunas
Created November 16, 2012 19:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save glarrain/4090294 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save glarrain/4090294 to your computer and use it in GitHub Desktop.
Download ZIP
Chile: Regiones, Provincias, Comunas
Raw
regiones-provincias-comunas
SELECT
comuna_nombre AS comuna,
provincia_nombre AS provincia,
region_nombre AS region
FROM comunas
INNER JOIN provincias ON
comunas.provincia_id = provincias.provincia_id
INNER JOIN regiones ON
provincias.region_id = regiones.region_id
WHERE region_ordinal LIKE "IX"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment