Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt

bartubozkurt/join_three_tables.sql

Created June 13, 2021 08:53
Show Gist options
  • Save bartubozkurt/bc47a7ee8de8c7455d448f30657b280a to your computer and use it in GitHub Desktop.
Save bartubozkurt/bc47a7ee8de8c7455d448f30657b280a to your computer and use it in GitHub Desktop.
Download ZIP
JOIN Three Tables Selects all orders with customer and shipper information:
Raw
join_three_tables.sql
SELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName
FROM ((Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID)
INNER JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment