Have you tried grouping by CUSTID?