Question

25. The president of the company wants a list of all orders ever taken. He wants to see the customer name, the last name of the employee who took the order, the shipper who shipped the order, the product that was ordered, the quantity that was ordered, and the date on which the order was placed. [Hint: You will need to join the following tables: Customers, Employees, Shippers, Orders, OrderDetails, Products, and to get all of the necessary information.]

attempted solution:

SELECT customers.CustomerName, employees.LastName, shippers.ShipperName, products.ProductName, orders.Quantity, od.OrderDetails.date

FROM Customers, Employees, Shippers, Orders, OrderDetails, Products JOIN customers.customerID = orders.customerID AND employees.employeeID = orders.employeeID AND orders.ordersID = orderdetails.orderID AND orderdetails.shipperID = Shippers.shipperID AND Products.productID = OrderDetails.productID;

Answer 1

Following is the updated Query for the above case.

SELECT customers.CustomerName, employees.LastName, shippers.ShipperName, products.ProductName, orders.Quantity, OrderDetails.date
FROM Customers INNER JOIN orders ON customers.customerID = orders.customerID
INNER JOIN employees ON employees.employeeID = orders.employeeID
INNER JOIN orderdetails ON  orders.ordersID = orderdetails.orderID
INNER JOIN shippers ON orderdetails.shipperID = Shippers.shipperID
INNER JOIN Products ON Products.productID = OrderDetails.productID;

Friend, That was a nice question to answer
If you have any doubts in understanding do let me know in the comment section. I will be happy to help you further.
Thanks