dIstinct count

[hnunez4399]

What would be the easist way to do the following..
I have two files being appeneded together with the fields below.

Unique sku#
Units
file1identifier


I want to get the count of unique skus for each file... Total units for each file and then a grand total of unique skus for both files and total units for both files...

Any help would be appreciated.
Thx,

 

[Melagan]

A starting point...

SELECT t.file1identifier
, Count(t.[unique sku#]) as CountofSKU
, Count(t.Units]) as CountofUnits

FROM tblYourTable as t

GROUP BY t.file1identifier

Sample data and expected results are always good

~Melagan
______
"It's never too late to become what you might have been.