title: Using the Minus statement to return result set
body: <p>I am using <strong>Oracle SQL Developer</strong>, I need to compare 2 tables and return the result set. The queries are tricky on this one, and I have not been able to come across an example that is similar to what I am trying to accomplish. </p>
  
  <p>I have attempted to create the query below but am not sure how to move forward, as the queries have different number of result columns. <strong>Some of the columns are similar but not exact</strong>, and I still want the result set to display the records from the first query, as I am just using the second query to make sure there are no duplicates in the table. </p>
  
  <p>I essentially will be asking the user for a number, in this case 15, the first query will return a result set, say of 20 records, I then need to use ORDER from the first query to check in the second query and then return all the records that appeared in the first set but not in the second. </p>
  
  <pre><code>SELECT MODEL, ORDR, CONSMR, PRODN 
  FROM a.Store // db schema
  WHERE (MODEL = '15') // No problems on this query
  
  MINUS
  
  SELECT MODEL, ORDR 
  FROM newStore 
  WHERE ORDR..... // Not sure what should go here
  </code></pre>