Skip to content

Instantly share code, notes, and snippets.

@tpitale

tpitale/gist:124989

Created June 6, 2009 19:45
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 tpitale/124989 to your computer and use it in GitHub Desktop.
Save tpitale/124989 to your computer and use it in GitHub Desktop.
Download ZIP
dm sql query
Raw
gistfile1.sql
SELECT "items"."id", "items"."item_code", "items"."item_number", "items"."description", "items"."size", "items"."retail", "items"."vintage"
FROM "items"
INNER JOIN "sale_items" ON "items"."id" = "sale_items"."item_id"
INNER JOIN "sales" ON "sale_items"."sale_id" = "sales"."id" AND "sale_items"."sale_sale_time" = "sales"."sale_time"
WHERE "sale_items"."sale_id" IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 58)
GROUP BY "items"."id", "items"."item_code", "items"."item_number", "items"."description", "items"."size", "items"."retail", "items"."vintage"
ORDER BY "items"."id"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment