Skip to content

Instantly share code, notes, and snippets.

@MorkHub

MorkHub/makeLetters.sql

Created January 21, 2016 12:53
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 MorkHub/d346c561b8058b6f0e11 to your computer and use it in GitHub Desktop.
Save MorkHub/d346c561b8058b6f0e11 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
makeLetters.sql
SELECT CustomerName, Address, Postcode
FROM Magazine, Subscription, Customer
WHERE MagazineName = ‘AQA Computing Now’
AND EndDate < ‘01/06/2010’
AND
Magazine.MagazineID = Subscription.MagazineID
AND
Subscription.CustomerID = Customer.CustomerID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment