Report Writer: Salesperson Name in Jobs Report


I am trying to create a report that provides a list of jobs with various information.  One of the fields I want to include in the list is the name from the "Salesperson" field.  I can pull in the employee NUMBER from that field, but can't pull in the name.

I am familiar with SQL, but using SQL in this tool never goes well for me.  I tried using the INNER JOIN function, but it just ends up displaying the code, not the result.