title: SQL JOIN WITH OR Condition
body: <p>I have a table say <strong>Cases</strong>, which is using reference from <strong>Workers</strong> for three columns. Also there is one table <strong>Company</strong> to which workers belongs.</p>
  
  <p>Below is the schema:</p>
  
  <pre><code>Cases [ CaseID, CaseNumber, Worker1, Worker2, Worker3 ] 
  Workers [ WorkerID, ComapnyID]
  Company [CompanyID, CompanyName]
  </code></pre>
  
  <p>Now I need case count for each company.
  So is it possible to make one join with workers and map all <strong>Worker1</strong>, <strong>Worker2</strong> and <strong>Worker3</strong> columns? Is there any better option and performance impact?</p>
  
  <p>Note: Two workers from one company can work on single case, or all the workers can be from different companies.</p>