25. The president of the company wants a list of all orders ever taken. He wants…

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.]

Place Order

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;