Want to compute count of distinct customers in the customer order table.
Compute Count CUSNUM from CUSORDER Works
Compute Count distinct CUSNUM from CUSORDER doesn't
duh?
Dick,
SELECT CusNum, (COUNT(CusNum)) FROM CusOrder GROUP BY CusNum
OR
SELECT CusNum, (COUNT(CusNum)) AS TotalCount FROM CusOrder GROUP BY CusNum
Have Fun!
Very Best R:egards,
Razzak.
