title: Exclude records matching subquery
body: <p>There is probably an obvious answer to this question, but I am having one heck of a time getting anywhere with it.</p>
  
  <p>Consider the query:</p>
  
  <pre>
  SELECT *
  FROM reports AS r
  JOIN reportvalues AS rv ON rv.report_id = r.report_id
  JOIN metrics AS m ON m.metric_id = rv.metric_id
  WHERE r.report_id NOT IN(
      SELECT DISTINCT report_id
      FROM exclude_report
  )
  </pre>
  
  <p>In this query, <code>exclude_report</code> is a view constructed in a similar manner.</p>
  
  <p>Now what happens is the query takes an EXTREMELY long time to execute, presumably because the subquery is being executed over each and every row in the parent query. However, I am finding no feasible means of doing this any other way.</p>
  
  <p>Oh great SQL wizards, please advise. I really need a way of doing this all in SQL, which I will be using in SSRS.</p>