Sort by: firstname | lastname | home department
A | B | C | D | E | F | G | H | I | J | K | L | M |
N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
SELECT * FROM people p, profile pf LEFT JOIN title t ON t.profile_id = pf.profile_id WHERE pf.people_id = p.people_id AND pf.profile_type = 'faculty' ORDER BY lastname, firstname, lastname ASC