Skip to content

Instantly share code, notes, and snippets.

@rrubo
Last active November 25, 2019 18:56
Show Gist options
  • Save rrubo/6bd9bd9a0cd7ddf773344602db30d077 to your computer and use it in GitHub Desktop.
Save rrubo/6bd9bd9a0cd7ddf773344602db30d077 to your computer and use it in GitHub Desktop.
SQL query for the Medium article
/* Selecting the needed columns from the Order and Customer tables */
SELECT OrderNumber, TotalAmount, FirstName, LastName, City, Country
/* Joining the rows of two tables... */
FROM [Order] JOIN Customer
/* ... that contain the same customer_id */
ON [Order].CustomerId = Customer.Id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment