Skip to content

Instantly share code, notes, and snippets.

@dbussink

dbussink/gist:15252

Created October 7, 2008 07:54
Show Gist options
  • Save dbussink/15252 to your computer and use it in GitHub Desktop.
Save dbussink/15252 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT "people"."id", "people"."name" FROM "people"
INNER JOIN "addresses" ON ("people"."id" = "addresses"."person_id")
WHERE ("addresses"."street" LIKE '%street%')
ORDER BY "people"."id"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment