Skip to content

Instantly share code, notes, and snippets.

@Goddard

Goddard/gist:623532

Created October 13, 2010 05: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 Goddard/623532 to your computer and use it in GitHub Desktop.
Save Goddard/623532 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT TotalAmount
FROM INVOICE
WHERE TotalAmount > 100.00 AND CustomerNumber =
(
SELECT FirstName, LastName
FROM CUSTOMER
WHERE CustomerID = CustomerNumber
)
@Goddard
Copy link
Author

Goddard commented Oct 13, 2010

SELECT TotalAmount
FROM INVOICE
WHERE TotalAmount > 100.00 AND CustomerNumber =
(
SELECT CustomerID
FROM CUSTOMER
WHERE CustomerID = CustomerNumber
);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment