Hi
Difficult to help with the info given, perhaps this will point you in the right direction?
SELECT
e.BuProductName
,MAX(s.OrderQuantity) as Sold
,CAST(SomeDate AS DATE)
FROM
dbo.Product AS e
INNER JOIN dbo.Transact AS s
ON e. productID= s. productID
GROUP BY
CAST(SomeDate AS DATE)
,e.BuProductName
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe