title: How to do a join with multiple conditions in the second joined table?
body: <p>I have 2 tables.  The first table is a list of customers.</p>
  
  <p>The second table is a list of equipment that those customers own with another field with some data on that customer (customer issue).  The problem is that for each customer, there may be multiple issues.</p>
  
  <p>I need to do a join on these tables but only return results of customers having two of these issues.</p>
  
  <p>The trouble is, if I do a join with OR, I get results including customers with only one of these issues.</p>
  
  <p>If I do AND, I don't get any results because each row only includes one condition.</p>
  
  <p>How can I do this in T-SQL 2008?</p>