title: SQL - Is there an opposite but equivalent UNION function?
body: <p>Is there an opposite but equivalent UNION function for mysql?</p>
  
  <p>I know it's possible to do this with a longer query but I'm curious on whether or not there's a function equivalent.</p>
  
  <p>I have 2 select statements for 2 different tables</p>
  
  <pre><code>select state, state_name, id, idname, phone, mobile, home from table1
  select state, state_name, id, idname, phone, mobile, home from table2
  </code></pre>
  
  <p>And I need a query that pulls only from table1 and ONLY if idname, phone, mobile, home from table1 doesn't match with table2</p>
  
  <p>For example: Table1 has</p>
  
  <pre><code>AK | Alaska | 1 | row6   | 453  | 567 | 123
  </code></pre>
  
  <p>but Table 2 has:</p>
  
  <pre><code>AK | Alaska | 1 | row6   | 453  | 567 | 123
  AK | Alaska | 1 | row6   | NULL | 567 | 123
  AK | Alaska | 1 | tttttt | 453  | 567 | 123
  </code></pre>
  
  <p>The query will display</p>
  
  <pre><code>AK | Alaska | 1 | row6   | NULL | 567 | 123
  AK | Alaska | 1 | tttttt | 453  | 567 | 123
  </code></pre>
  
  <p>will NOT display</p>
  
  <pre><code>AK | Alaska | 1 | row6   | 453  | 567 | 123
  </code></pre>