[no subject]

SELECT COPY.owner COPY.title_key TITLE.name from TITLE COPY where 
TITLE.title_key = COPY.title_key order by COPY.owner;

This is not tested so....

Hope this helps.

On Jan 21, 2004, at 10:19 AM, Jason Etheridge wrote:

> Hi guys, this has been driving me nuts and maybe you would enjoy 
> figuring it out. :)
>
> I have two tables: TITLE and COPY.  There is a one-to-many 
> relationship between the two; for any given title, there could be many 
> copies.  Copies have owners, but titles don't belong to anyone.
>
> 	table TITLE:
> 		field title_key	PRIMARY KEY
> 		field name	CHAR
> 	table COPY:
> 		field copy_key	PRIMARY KEY
> 		field title_key	FOREIGN KEY
> 		field owner	CHAR
>
> However, owners would like a list of what titles they happen to have 
> copies for.  I can do this through brute-force with a programming 
> language, but is there a single SQL query I could use?  Specifically, 
> MySQL (I don't have sub-selects)?
>
> I'm sure this is simple and obvious and I'll feel like more of an 
> idiot later.  *8)
>
> Thanks,
> Jason
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt;


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<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-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>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00845.html">[ale] USB-&gt;IDE problems</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00847.html">[ale] any SQL gurus?</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00844.html">[ale] any SQL gurus?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00851.html">[ale] any SQL gurus?</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00846"><strong>Date</strong></a></li>
<li><a href="threads.html#00846"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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