title: NOT IN Clause for Multiple columns in SQL
body: <p>I have a SQL query  : </p>
  
  <pre><code>select * from  product_structure_resources 
  where resource_id NOT IN (select resource_id from resources);
  </code></pre>
  
  <p>Now I need to add the columns like branch_id and scheme_id right after the where clause . </p>
  
  <p>Like : </p>
  
  <pre><code>select * from  product_structure_resources 
  where resource_id,scheme_id,branch_id NOT IN (select resource_id from resources);
  </code></pre>
  
  <p>How can I do it ? </p>
  
  <p>P.S : The resources table does not have scheme_id and branch_id column in it. It has only resource_id column .</p>