title: SQL in-line equivalent to intersect
body: <p>Is there an inline sql command that is similar to or produces the same results as <code>intersect</code>? If not is there a way to rewrite the query so it is in one query rather than using <code>intersect</code>?</p>
  
  <p>My current sql query is:</p>
  
  <pre><code>SELECT 
    c.Log_Link 
  FROM 
    Classes c INNER JOIN 
    ClassValues cv ON c.Class_Link = cv.Class_Link INNER JOIN 
    ClassSelection cs ON cv.ClassSelection_Link = cs.ClassSelection_Link
  WHERE 
    cs.classselection_link IN (95,1)
  </code></pre>
  
  <p>But what I'm really after is:</p>
  
  <pre><code>SELECT 
    c.Log_Link 
  FROM 
    Classes c INNER JOIN 
    ClassValues cv ON c.Class_Link = cv.Class_Link INNER JOIN 
    ClassSelection cs ON cv.ClassSelection_Link = cs.ClassSelection_Link
  WHERE 
    cs.classselection_link = 95 
  INTERSECT 
  SELECT 
    c.Log_Link 
  FROM 
    Classes c INNER JOIN 
    ClassValues cv ON c.Class_Link = cv.Class_Link INNER JOIN 
    ClassSelection cs ON cv.ClassSelection_Link = cs.ClassSelection_Link
  WHERE 
    cs.classselection_link = 1
  </code></pre>
  
  <p>Thanks</p>