Re: Using DISTINCT AND SUM together SQL question

You don't need distinct. Just use a group by:

select item, rev, sum(qty)
from ...
group by 1, 2

Cim Received on Sat Apr 13 2002 - 03:17:37 CDT