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.