title: SQL Query Help: Fetch all rows with same first name and with a last names matching a defined list
body: <p>Table Design:</p>
  
  <pre><code>First_Name Last_name
  </code></pre>
  
  <p>There are several records which have same first name but different last name. I need to find all the records which have same first name and a defined list of last name.</p>
  
  <p>For example:</p>
  
  <pre><code>First_Name Last_name
  John       Pohn
  John       Qohn
  John       Rohn
  Jack       Rohn
  Jack       Pohn
  Sam        Pohn
  Sam        Rohn
  Sam        Qohn
  </code></pre>
  
  <p>Last name list: Pohn and Qohn</p>
  
  <p>Thus my query should only pick these records</p>
  
  <pre><code>John Pohn
  John Qohn
  Sam  Pohn
  Sam Qohn
  </code></pre>