Skip to content

Instantly share code, notes, and snippets.

@danmatthews
Created March 8, 2012 10:41
Show Gist options
  • Save danmatthews/2000345 to your computer and use it in GitHub Desktop.
Save danmatthews/2000345 to your computer and use it in GitHub Desktop.
SELECT e.date_subscribed,
countries.name
FROM countries
JOIN contacts c
LEFT OUTER JOIN contacts_economic_updates_countries e
ON e.country_name = countries.name
WHERE c.contact_id='80d0624061395e3d9f108165cd163e004a2ed12e37def2995f866d82dd40b3f2'
ORDER BY countries.name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment