How to combine rows from two tables with INNER JOIN in SQL

2 Answers

0 votes
SELECT Orders.OrderID, Customers.CustomerID, Orders.OrderTime, Orders.TotalCost
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID

 



answered Sep 19, 2015 by avibootz
0 votes
SELECT Orders.OrderID, Customers.CustomerID, Orders.OrderTime, Orders.TotalCost
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID
ORDER BY Orders.TotalCost

 



answered Sep 19, 2015 by avibootz
...