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 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 gryProblem
HINT: Try nesting queries. ThAproblem can be solved with just two queries. Name the first query gryProblemA and name the final query gry Problem which shows the dynaset described above.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
