Question: Write a statement that displays the following fields: title , customer's first name, customer's last name, item ID ( from Order _ Details _ Copy

Write a statement that displays the following fields: title, customer's first name, customer's last name, item ID (from Order_Details_Copy table),The statement will determine which items Yash Randall has purchased and order by item ID descending. Perform the search using the customer name, not the customer number. The query will join these 4 tables together: Customers_Copy, Orders_Copy, Order_Details_Copy, and Items_Copy. The fields should be displayed in the order listed. Results 5 rows.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!