Skip to content

Instantly share code, notes, and snippets.

@chilversc

chilversc/sql query

Forked from anonymous/sql query
Created December 14, 2011 23:33
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 chilversc/1479112 to your computer and use it in GitHub Desktop.
Save chilversc/1479112 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