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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement