title: Joining Oracle ApEx collections to actual tables
body: <p>Within Oracle ApEx is it possible to join an actual table in your schema to an Oracle ApEx Collection, as I am having trouble doing so?</p>
  
  <p>Basically have the following scenario:</p>
  
  <pre><code>select c001,  -- employee id from collection
         c002,
         c003   -- employee dept no from collection
  from   apex_collections,
         emp
  where  emp.id = c001
  and    emp.deptno = c003;
  </code></pre>
  
  <p>Is the above possible or am I missing something?</p>