![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 24.02.2020 19:32 tdluong157
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.]
Query
Number of records returned
[Source: w3schools. com] [Database Tables: Customers, Categories, Employees, OrderDetails, Orders, Products, Shippers, Suppliers]
Attempted sol'n:
SELECT ShipperName, CustomerName, Employees. LastName FROM Shippers, Customers, Employees
JOIN OrderDetails ON OrderDetails. ID = Orders. OrderDetailID
JOIN Customers ON Customers. customerID = Orders. customerID
JOIN Employees ON Employees. employeeID = Orders. employeeID
JOIN Shippers ON Shippers. ID = OrderDetails. shipperID
JOIN Products ON OrderDetails. ProductID = Products. ID;
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 16:20, kimmmmmmy333
Octothorpe is another name for what common computer keyboard symbol?
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 17:30, uh8hardiek
Ou listened to a song on your computer. did you use hardware or software?
Answers: 2
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 19:20, SundaeSunday
Consider the following code snippet: #ifndef cashregister_h#define cashregister_hconst double max_balance = 6000000.0; class cashregister{public: cashregister(); cashregister(double new_balance); void set_balance(double new_balance); double get_balance() const; private: double balance[12]; }; double get_monthly_balance(cashregister bk, int month); #endifwhich of the following is correct? a)the header file is correct as given. b)the definition of max_balance should be removed since header files should not contain constants. c)the definition of cashregister should be removed since header files should not contain class definitions. d)the body of the get_monthly_balance function should be added to the header file.
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 10:30, badpotterchris
How would you categorize the software that runs on mobile devices? break down these apps into at least three basic categories and give an example of each.
Answers: 1
You know the right answer?
The president of the company wants a list of all orders ever taken. He wants to see the customer nam...
Questions in other subjects:
![Konu](/tpl/images/cats/mat.png)
Mathematics, 02.02.2021 16:20
![Konu](/tpl/images/cats/istoriya.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 02.02.2021 16:20
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/himiya.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 02.02.2021 16:20
![Konu](/tpl/images/cats/geografiya.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 02.02.2021 16:20
![Konu](/tpl/images/cats/es.png)
Spanish, 02.02.2021 16:20