title: MINUS operator in MySQL?
body: <p>I have some tables where I am getting the emails. And I don't want to get the emails in table <code>tbl_unsubscribe</code>. I wrote the query like :</p>
  
  <pre><code>SELECT cand_email FROM tbl_cand_data
  UNION
  SELECT emp_email FROM tbl_emp_data
  UNION
  SELECT email FROM tbl_uptade_list
  UNION
  SELECT feed_email FROM tbl_feedback
  UNION
  SELECT admin_email FROM tbl_admin_emails    
  </code></pre>
  
  <p>But I am getting a syntax error. Is the <code>MINUS</code> operator not valid for MySQL ?</p>