Question: Problem 6 1 The inventory manager wants to know the wholesale cost of all the backerders, displayed by item number. The baekorders were made to

Problem 61 The inventory manager wants to know the wholesale cost of all the backerders, displayed by item number. The baekorders were made to the suppliers with the lowest cost offered for each inventory item. He wants a dynaset that shows each backordered item with the following columns from left to right: the inventory ID, the name the item, the negative quantity on hand (which is the same as the quantity ordered), the lowest supplier cost of that item, and a last column called BackOrderTotal, which is the quantity on backorder multiplied by the lowest cost for that item, which should be displayed as a positive, not negative, dollar figure. Name this query gryProblem6.
HINT: Try nesting queries. ThAproblem can be solved with just two queries. Name the first query gryProblem6A and name the final query gry Problem6, which shows the dynaset described above.

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 Databases Questions!