title: How to select rows where multiple joined table values meet selection criteria?
body: <p>Given the following sample table schema</p>
  
  <p>Customer Table</p>
  
  <pre><code>CustID
  1
  2
  3
  </code></pre>
  
  <p>Invoice Table</p>
  
  <pre><code>CustID InvoiceID
  
  1       10
  1       20
  1       30
  2       10
  2       20
  3       10
  3       30
  </code></pre>
  
  <p>The objective is to select all customers who have an InvoiceID value of 10 and 20 (not OR). So, in this example customers w/ CustID=1 and 2 would be returned.</p>
  
  <p>How would you construct the SELECT statement?</p>