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
- Original Message -
From: "Franklin Williams Jr." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 9:44 PM
Subject: self relation query help
> I have a table with names in it where the names can function as 1 of 2
things -
> either an art
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 search only one table. The problem aris