Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@geobabbler

geobabbler/simple_join.sql

Created May 8, 2015 14:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save geobabbler/461bb9375afa2e24ddc6 to your computer and use it in GitHub Desktop.
Save geobabbler/461bb9375afa2e24ddc6 to your computer and use it in GitHub Desktop.
Download ZIP
Simple join example for blog post
Raw
simple_join.sql
SELECT
us_states_squares.shape,
us_states_squares.abbr,
us_states_squares.name,
vw_statistics_ytd.ytd
FROM
public.us_states_squares
INNER JOIN public.vw_statistics_ytd ON
us_states_squares.abbr = vw_statistics_ytd.state_abbr
WHERE
vw_statistics_ytd.year = 2015;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment