Skip to content

Instantly share code, notes, and snippets.

@dmulvi

dmulvi/left_outer_join.sql

Created May 30, 2014 04:06
Show Gist options
  • Save dmulvi/38ed6cada879f51b366e to your computer and use it in GitHub Desktop.
Save dmulvi/38ed6cada879f51b366e to your computer and use it in GitHub Desktop.
Download ZIP
LEFT OUTER JOIN example
Raw
left_outer_join.sql
SELECT f.id, f.screen_name, l.location
FROM followers AS f
LEFT OUTER JOIN location AS l
ON l.id = f.id
LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment