Show the LastName, FirstName, Phone, and TotalAmount of all customer orders that included an Item named Dress Shirt Also show the LastName, FirstName, and Phone of all other customers Present results sorted by TotalAmount in ascending order, then LastName in ascending order, and then FirstName in descending order HINT In Microsoft Access 2016, you will either need to use a UNION statement or a sequence of two queries to solve this because Microsoft Access disallows nesting an INNER join inside a LEFT OUTER or RIGHT OUTER join The other DBMS products can complete this question with one query (not a UNION statement)

Question

Show the LastName, FirstName, Phone, and TotalAmount of all customer orders that included an Item named Dress Shirt  Also show the LastName, FirstName, and Phone of all other customers  Present results sorted by TotalAmount in ascending order, then LastName in ascending order, and then FirstName in descending order  HINT  In Microsoft Access 2016, you will either need to use a UNION statement or a sequence of two queries to solve this because Microsoft Access disallows nesting an INNER join inside a LEFT OUTER or RIGHT OUTER join  The other DBMS products can complete this question with one query (not a UNION statement)

Accepted Answer

The Answer is in the image, click to view ...

Question

Show the LastName, FirstName, Phone, and TotalAmount of all customer orders that included an Item named Dress Shirt. Also show the LastName, FirstName, and Phone

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Professional SQL Server 2000 Database Design

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question