The following SQL statement selects all orders with customer information:
SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
Practice Excercise Practice now