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
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
