Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Simple join example for blog post
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