How about SELECT COUNT(DISTINCT CUSNUM) FROM CUSORDER
Dennis McGrath --- Dick <[EMAIL PROTECTED]> wrote: > 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? >

