All 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 eepy.group=2 AND eepy.status<>'Q' AND eepy.status<>'W' AND (categories.GCateg='F' OR categories.GCateg='X' OR categories.GCateg='B' OR categories.GCateg='R' OR categories.GCateg='A') ORDER BY eepy.namei