My goal is to build a page for the physician office so that I can display all the physician's practice areas together and alphabetically. The office is already linked to the physician records. The areas aren't entered alphabetically to start with, but by importance. I thought that one choice would be to move the practice areas off to to a separate table and then display the results with ORDER by ASC. But ORDER by will want to choose a single column which doesn't seem to help here.
Of course if ALL of the records were in one column that would work. Maybe concat would help here? Suggestions please.
well, part of the problem is that rather than choosing from a list of practice areas, each person is allowed to decide on a special practice area. this has been confusing; still, because of the repetitive nature of that field, these probably do need to go into a separate table and get a foreign key to the physician. but if each physician is linked to a separate field with practice areas, and we are looking at a group of physicians, how can all of those practice areas be made alphabetical?