Skip to content

Instantly share code, notes, and snippets.

@alexanderjsingleton

alexanderjsingleton/joins.sql

Last active May 15, 2016 12:09
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 alexanderjsingleton/5fe71c0c3ef0f14aad7949bfa2111489 to your computer and use it in GitHub Desktop.
Save alexanderjsingleton/5fe71c0c3ef0f14aad7949bfa2111489 to your computer and use it in GitHub Desktop.
Download ZIP
A simple JOINS statement provided for [my blog-post on databases](https://www.alexanderjsingleton.com/event-horizon-data-centric-future)
Raw
joins.sql
-- A basic JOINS SQL statement resembling VLOOKUP
SELECT s.student_id,
z.state AS "STATE"
FROM STUDENT.STUDENT s
JOIN student.zipcode z ON s.zip=z.zip
ORDER BY s.STUDENT_ID;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment