title: SQL statement to return overlap from two Select Statements
body: <p>I have a table on SQL server and two Select statements with different WHERE criteria</p>
  
  <p>What I want are the results that match both Select Statements, not just one.</p>
  
  <p>I've tried nested SELECT statements but I'm not having much luck.</p>
  
  <p>My table looks like the follow</p>
  
  <pre><code>ID    Name    Field2    Field3
  
  1     John     100       NULL
  2     Dave     150       NULL
  3     Tim      NULL      150
  4     Dave     NULL      150
  </code></pre>
  
  <p>And my SELECT statements are as follows:</p>
  
  <pre><code>SELECT * FROM table WHERE Field2 = 150
  SELECT * FROM table WHERE Field3 = 150
  </code></pre>
  
  <p>But I want to return just 'Dave' because only he appears in the results for both SELECT statements.</p>
  
  <p>How do I achieve this?</p>