Skip to content

Instantly share code, notes, and snippets.

@joyadauche
Last active January 2, 2020 16:24
Joins in SQL- INNER JOINS: complete code for joining Person, Grade and Activity Tables (refactored)
SELECT name, score, activity, a.year
FROM person AS p
INNER JOIN grade AS g
USING(id)
INNER JOIN activity AS a
USING(id, year)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment