How would you write and index expression for a table using its foreign key but ordering it by the descriptive text field the key relates to in anonther table? In other words, the incidents table has an employeeid field that can be related to the employees table by saying incidents.emloyeeid = employees.employeeid. The employees table has first name, last name ect. I simply want to set the order of the incidents table to last name.

Thanks for any help.