title: Query to list all invoices for customers with more than one
body: <p>Here's a simplified version of the two tables:</p>
  
  <pre><code>Invoice
  ========
  InvoiceID
  CustomerID
  InvoiceDate
  TransactionDate
  InvoiceTotal
  
  Customer
  =========
  CustomerID
  CustomerName
  </code></pre>
  
  <p>What I want is a listing of all invoices where there is more than one per customer. I don't want to group or count the invoices, I actually need to see all invoices. The output would look something like this:</p>
  
  <pre><code>CustomerName    TransactionDate    InvoiceTotal
  -------------------------------------------------
  Ted Tester      2012-12-14         335.49
  Ted Tester      2013-02-02         602.00
  Bob Beta        2013-05-04         779.50
  Bob Beta        2013-07-07          69.00
  Bob Beta        2013-09-10         849.79
  </code></pre>
  
  <p>What's the best way to write a query for SQL Server to accomplish this?</p>