I hope I can explain the situation well enough that those of you that are database peeps can offer recommendations.
Situation: A large list of primary names, each with up to three aliases, along with other info.
Desired output: An alphabetic list by name that shows the info including the aliases, plus within the list in the appropriate places alphabetically, the alias names with the associated primary name.
So... would it be best to put it all in one table with fields for name, alias1, alias2, alias3, etc.
OR
Would two tables, one with the primary names and info, then a second table with aliases and the associated primary name?
I'm using PHP and a Mysql database.
Thx
