Skip to content

Instantly share code, notes, and snippets.

@LocalCommit

LocalCommit/sql.sql

Created April 12, 2015 16:53
Show Gist options
  • Save LocalCommit/22c6106666e752383107 to your computer and use it in GitHub Desktop.
Save LocalCommit/22c6106666e752383107 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql.sql
SELECT joke.id, joketext, email, category.name, author.name
FROM joke
INNER JOIN author ON authorid = author.id
INNER JOIN jokecategory ON joke.id = jokeid
INNER JOIN category ON categoryid = category.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment