[no subject]

	I think GROUP BY would come in handy.  Lemme see, it's been a few years
here, so pardon the rustiness of the following:

	select count(*), t.name
          from TITLE t, COPY c
         where c.title_key = t.title_key
      group by t.name

and this is from the INGRES dialect, so "count(*)" may not be proper in
ANSI SQL.

-- 
kernel, n.: A part of an operating system that preserves the
medieval traditions of sorcery and black art.

Danny


</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="00838" href="msg00838.html">[ale] any SQL gurus?</a></strong>
<ul><li><em>From:</em> phasefx at magusaptus.com (Jason Etheridge)</li></ul></li>
<li><strong><a name="00846" href="msg00846.html">[ale] any SQL gurus?</a></strong>
<ul><li><em>From:</em> ale at jeffx.com (Jeff Tillotson)</li></ul></li>
<li><strong><a name="00851" href="msg00851.html">[ale] any SQL gurus?</a></strong>
<ul><li><em>From:</em> phasefx at magusaptus.com (Jason Etheridge)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00861.html">[ale] Novell and the Linux Desktop</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00863.html">[ale] DLT system?</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00859.html">[ale] any SQL gurus?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00840.html">[ale] RE: Ale Digest, Vol 5, Issue 83</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00862"><strong>Date</strong></a></li>
<li><a href="threads.html#00862"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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