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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.