Faculty & Staff
| Name |
Title |
E-mail |
SELECT ID, firstName, lastName, title, email
FROM faculty
WHERE departmentID =
(SELECT departmentID
FROM departments
WHERE departmentName = 'Physics and Astronomy')
AND title <> 'Adjunct Professor'
ORDER BY faculty.lastName, faculty.firstName
Error: Could not connect to database.
|
#firstName# #lastName#
|
#title#
|
#email#
|
| |
SELECT ID, firstName, lastName, title, email
FROM faculty
WHERE departmentID =
(SELECT departmentID
FROM departments
WHERE departmentName = 'Physics and Astronomy')
AND title = 'Adjunct Professor'
ORDER BY faculty.lastName, faculty.firstName
Error: Could not connect to database.
|
#firstName# #lastName#
|
#title#
|
#email#
|
Documents and files for DPA faculty; requires login
