Re: SQL: How to display one record from a file without affecting the others

Chuck,

Not the way I read the original request...
"What I want is (by using the component item and the warehouse id) to pull
in the FINISHED ITEM that is most often associated with a component item"

I read "most often associated" as needing to count the grouping of
component item/finished item then pick the max value.

But I do agree that my answer is not complete by itself and the OP
will have to build upon it or provide more details.

Charles


On Tue, Apr 20, 2010 at 3:45 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

  What was requested was the one "finished item" with the MAXimum
SUMmation of the Quantity values, not the MAXimum COUNT of items,
for the noted combination\group of Component Item and Warehouse Id;
i.e. Finished Item 7777A with the sum of quantities 45 were the
requested data to be added to the query result set.