Skip to content

Instantly share code, notes, and snippets.

/sql query

Created December 14, 2011 23:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save anonymous/1479096 to your computer and use it in GitHub Desktop.
Save anonymous/1479096 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql query
SELECT os.orders_status_id, os.date_added, os.customer_notified, os.comments, o.customers_id, o.customers_email_address, o.orders_status, o.date_purchased, c.customers_id, c.entry_appt_needed AS yns FROM orders_status_history os, orders o JOIN address_book c ON c.customers_id = o.customers_id where os.orders_id = 113
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment