Skip to content

Instantly share code, notes, and snippets.

@nashibao
Last active November 30, 2016 14:22
Show Gist options
  • Save nashibao/c13d9cb96c945c262ac8a56a3017048c to your computer and use it in GitHub Desktop.
Save nashibao/c13d9cb96c945c262ac8a56a3017048c to your computer and use it in GitHub Desktop.
blog4.sql
SELECT hoge FROM a
JOIN
(SELECT fuga FROM b GROUP BY fuga) AS c
ON a.hoge = c.fuga
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment