How to create SQL-Statement for this

[erickwidya]

well..i can manage to do with 2 query..don't if this what u want or not..(in Access)
well this is it

queDistinct

SELECT DISTINCT Table1.ProductID, Sum(Table1.Count) AS SumOfCount, Table2.ClientNO
FROM Table1 INNER JOIN Table2 ON Table1.[No] = Table2.[No]
GROUP BY Table1.ProductID, Table2.ClientNO;

queFinal

SELECT queDISTINCT.ProductID, Sum(queDISTINCT.SumOfCount) AS TotalCountt, Count(queDISTINCT.ClientNO) AS DiffClients
FROM queDISTINCT
GROUP BY queDISTINCT.ProductID;

PS : this is the query from ACCESS