Skip to content

Instantly share code, notes, and snippets.

/post.sql

Created July 21, 2016 06:37
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 anonymous/30771719bd7c2f60a8b231508fdd6fde to your computer and use it in GitHub Desktop.
Save anonymous/30771719bd7c2f60a8b231508fdd6fde to your computer and use it in GitHub Desktop.
Download ZIP
the description for this gist
Raw
post.sql
SELECT u.id, u.name, u.is_active, d.id, d.name, d.user_id FROM users u
LEFT JOIN devices d ON u.id = d.user_id WHERE u.id = ?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment