Skip to content

Instantly share code, notes, and snippets.

@nikoncode

nikoncode/temp.sql

Created June 15, 2014 22:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nikoncode/d1afe63a2374a682f673 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nikoncode/d1afe63a2374a682f673 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
temp.sql
SELECT routes.name,
CONCAT(fname,' ',lname) AS fio
FROM routes
LEFT JOIN comp_riders ON routes.id = comp_riders.rid
LEFT JOIN users ON comp_riders.uid = users.id
WHERE routes.cid = 4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment