title: MYSQL - Returning select statement when not correct?
body: <p>Here's what i am trying to achieve:</p>
  
  <p>Table one shows where certain products SHOULD be located on a system.<br>
  Table two shows where the products ACTUALLY are based on a live environment.</p>
  
  <p>What i would like is to only return rows in Table Two IF they are in the incorrect location based on TABLE ONE. </p>
  
  <p>Below is how the tables would look:</p>
  
  <p><a href="https://i.stack.imgur.com/iqghv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iqghv.png" alt="enter image description here"></a></p>
  
  <p>I've tried putting together my own query as below</p>
  
  <pre><code>SELECT product, location
  FROM Table 2
  WHERE product, location NOT IN
                (SELECT product, location  
                 FROM Table 1)
  ORDER BY LOCATION
  </code></pre>