Note: Some of the graphical elements
of this site are only visible to browsers that support accepted
web standards. The content of
this site is, however, accessible to any browser or Internet device.
Academic Faculty Staff
SELECT eepy.formal, eepy.status, categories.category, categories.gcateg, statuses.statusdesc, eepy.eeid FROM (eepy INNER JOIN categories ON eepy.Categ = categories.Categ) INNER JOIN Statuses ON eepy.Status = Statuses.Status WHERE categories.gcateg='F' AND eepy.group=2 AND eepy.status<>'Q' AND eepy.status<>'W' ORDER BY eepy.namei