title: Translating INTERSECT statement to MySQL
body: <p>I have the following query using INTERSECT and I can't figure out how to translate it to MySQL using INNER JOIN.</p>
  
  <pre><code>SELECT DISTINCT Title, Variable FROM Table WHERE Location='Location1' AND Date='Date1'  
  INTERSECT  
  SELECT DISTINCT Title, Variable FROM Table WHERE Location='Location2' AND Date='Date2'  
  INTERSECT  
  SELECT DISTINCT Title, Variable FROM Table WHERE Location='Location3' AND Date='Date3'
  </code></pre>
  
  <p>Can anyone give me a hand?</p>