title: Oracle APEX interactive Grid displays too many duplicates
body: <p>I have 3 tables: Employees, Locations, and EmpLocation</p>
  
  <ul>
  <li>Employees stores employee data with Employee_ID as primary key, </li>
  <li>Locations stores location data with Location_ID. </li>
  <li>EmpLocation stores Employee_ID and Location_ID. Each Employee can have multiple locations.</li>
  </ul>
  
  <p>I have created an Interactive Grid that is based on the data from EmpLocation table:</p>
  
  <pre><code>SELECT EMPLOYEE_ID, LOCATION_ID
  FROM EmpLocation
  GROUP BY EMPLOYEE_ID, LOCATION_ID
  </code></pre>
  
  <p>Then each of the columns I set as a select list and use SQL query as a source:</p>
  
  <pre><code>SELECT Employee_FName, Employee_ID FROM Employees
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT LocationName, Location_ID FROM Locations
  </code></pre>
  
  <p>Everything looks fine but when I run query</p>
  
  <pre><code>SELECT EMPLOYEE_ID, LOCATION_ID
  FROM EmpLocation
  GROUP BY EMPLOYEE_ID, LOCATION_ID
  </code></pre>
  
  <p>in TOAD, I get about 100 records; but in the grid I get many duplicates. Cannot figure out what is going on...</p>