Posted by Chris Boget on 04/19/05 22:23

> I can do that, but is there a better way? How do you all handle
> dynamic sorting of normalized DBs?

Firstly, what DB are you using?
Secondly, just select and sort on the columns. An example query
would be:

SELECT
course.name,
location.name,
instructor.name
FROM
course
INNER JOIN location ON location.id = course.locationID
INNER JOIN instructor ON instructor.id = course.instroctorID
ORDER BY instructor.name

(or location.name or course.name).

It should be as simple as that...

thnx,
Chris

[Back to original message]