You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.
You add the related table Compensation to the query.
When you preview the query, you only get the current compensation information for the employees.
Why do you only receive the current records?
Note: There are 2 correct answers to this question.
Currently there are no comments in this discussion, be the first to comment!