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. Wi
tware.com]
Sent: Saturday, 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
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 hav
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 Messag
