[no subject]

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


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00852" href="msg00852.html">[ale] any SQL gurus?</a></strong>
<ul><li><em>From:</em> matthew.brown at cordata.com (Matthew Brown)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00858.html">[ale] USB-&gt;IDE problems</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00860.html">[ale] USB-&gt;IDE problems</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00852.html">[ale] any SQL gurus?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00862.html">[ale] any SQL gurus?</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00859"><strong>Date</strong></a></li>
<li><a href="threads.html#00859"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>