What else must you do?

In the Advanced Reporting tool, you want to create a query where the results meet the following criteria

• Only show one row per employee,

• Only show thepay components Base Salary and Bonus,

• Show these pay components as individual columns.

You have joined the Global Job Information table with the Compensation table.

What else must you do? Note: There are 2 correct answers to this question.
A . Configure atable restriction of the Compensation table.
B . Duplicate the Compensation table.
C . Configure a table restriction of the Global Job Information table.
D . Change the table join to the Compensation table to an inner join.

View Answer

Answer: A,C