Skip to content

Instantly share code, notes, and snippets.

@srsgores srsgores/all_pokemon.sql
Last active Nov 11, 2017

Embed
What would you like to do?
Query pokemon data
SELECT p.species_id, p.height, p.weight, p.base_experience, p.is_default, ps.*, pev.* FROM pokemon p
INNER JOIN pokemon_species ps on ps.id=p.id
INNER JOIN pokemon_evolution pev on pev.id=p.id
INNER JOIN pokemon_stats pstat on pstat.pokemon_id=p.id
@srsgores

This comment has been minimized.

Copy link
Owner Author

commented Nov 11, 2017

Getting duplicates...
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.