How do you configure the query to return one row per employee that shows the employee’s matrix manager when assigned?

In the Advanced Reporting tool, you want to create a query that includes the employee’s matrix manager. When you configure the table join with the Job Relationships table, the Results tab displays multiple rows per employee that also include relationships to HR managers and second managers.

How do you configure the query to return one row per employee that shows the employee’s matrix manager when assigned?
A . Change the Job Relationship join to a left join.
B. Change the Job Relationship to include a table restriction.
C. Change the Job Relationship join to a right join.
D. Change the Job Relationship join to an inner join.

View Answer

Answer: D