Skip to content

Instantly share code, notes, and snippets.

@nicolascarrascob

nicolascarrascob/MySQL-Chile:regiones-provincias-comunas

Forked from juque/MySQL-Chile:regiones-provincias-comunas
Created November 23, 2020 17:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nicolascarrascob/3b5b7d3ed72d3c4d0bf0d2d62f45c71f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nicolascarrascob/3b5b7d3ed72d3c4d0bf0d2d62f45c71f 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