title: NOT IN query using an apex collection
body: <p>I have a form with a select list. Before, we were only concerned with the user selecting one survey name, but now we want to store several survey names in a collection.</p>
  
  <p>Also, once the survey name has been selected, it should no longer appear in the list. The query before is as follows:</p>
  
  <pre><code>Select survey_name, survey_id  
  from SURVEYS  
  </code></pre>
  
  <p>Simple list. I have written queries before using NOT IN but they were based on tables. I'm having trouble creating my LOV and incorporating a collection. I have tried the following</p>
  
  <pre><code>SELECT survey_name N, survey_id S  
  FROM SURVEYS  
  where survey_id NOT IN (  
     SELECT ac.c003  
     FROM apex_collections ac  
     WHERE ac.collection_name = 'BENCHMARKS' )  
  </code></pre>
  
  <p>I am using a popup LOV and the list is not populating. I'm not sure what to do with this or if it is even possible to do such a query with collections. The collection is being created everytime you go to the page. When you navigate away from the page, it's not expected to save the values.</p>
  
  <p>Any help on this would be greatly appreaciated. Thanks in advace</p>