Quote Originally Posted by Kyle123 View Post
or using your sample database:
Code:
SELECT prsnl.id, 
       prsnl.[last name], 
       prsnl.[first name], 
       prsnl.rank, 
       prsnl.enterpriseemail, 
       prsnl.raterid, 
       rater.raterlastname, 
       rater.raterfirstname, 
       rater.ratermi, 
       rater.rateremail, 
       prsnl.srraterid, 
       srRater.raterlastname   AS srRaterLastName, 
       srRater.raterfirstname  AS srRaterFirstName, 
       srRater.ratermi         AS srRaterMI, 
       srRater.rateremail      AS srRaterEmail, 
       prsnl.reviewerid, 
       reviewer.raterlastname  AS reviewerLastName, 
       reviewer.raterfirstname AS reviewerFirstName, 
       reviewer.ratermi        AS reviewerMI, 
       reviewer.rateremail     AS reviewerEmail 
FROM   (((prsnl prsnl 
       LEFT JOIN tblraters rater 
         ON prsnl.raterid = rater.raterid)
       LEFT JOIN tblraters srRater 
         ON prsnl.srraterid = srRater.raterid)
       LEFT JOIN tblraters reviewer 
         ON prsnl.reviewerid = reviewer.raterid) 
ORDER  BY prsnl.[last name], 
          prsnl.[first name]


Awesome...That was it. Thank you very much.