, October 26, 2002 6:43 AM
To: Franklin Williams Jr.; [EMAIL PROTECTED]
Subject: Re: self relation query help
Franklin, the basic relational rules
(http://hometown.aol.com/mbaddenda/art120.html,
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html) say,
decompose relationships like your
This is probably going more into db design than pure mysql issues...on
the other hand if performance is at stake with these different
designs.
After several inputs - which I am EXTREMELY thankful for - here are
some of my thoughts. The solution using Joseph's table aliases works
beautifully.
Franklin, the basic relational rules
(http://hometown.aol.com/mbaddenda/art120.html,
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html) say,
decompose relationships like your artists groups to separate tables, and
your example fits right in.
PB
-
- Original Message
Franklin Williams Jr. wrote:
I have a table with names in it where the names can function as 1 of 2
things -
either an artist or a group. In order to make searching easy I wished
to keep
these names in one table. EG: searching for artist name, whether a
group or
soloist you would have to