On Jan 21, 2004, at 11:13 AM, Matthew Brown wrote: > Nahh.. No need for a sub-select on this one. Lemme ponder. Thanks. :) J.M. Taylor knew what I was doing wrong with DISTINCT and COUNT. I needed to treat DISTINCT as a function and pass it into COUNT like so: SELECT COUNT(DISTINCT(title_key)) FROM COPY WHERE owner = "Joe"; I appreciate everyone's help. -- Jason