Use this Query Assistant window to ensure that items between two or three tables are equal in order to be used in the report.
Example
You might want to select the ACD item from each agent and make a join clause to ensure that the report is for the same ACD information across the tables.