title: MySQL Join at a loss
body: <p>Please help anyone!</p>
  
  <p>I would like, <strong>for example</strong>, user_id 27 to return case_id 1 and 2 because another user_id with the same company has created the cases.</p>
  
  <p>User ID 27 is an example as the table is quite large and so I would need a generalised SQL statement somehow.</p>
  
  <p>A CodeIgniter Active Query would be very helpful but may be too complex?</p>
  
  <pre><code>Cases
  case_id | case_user | case_name
  1, 25, Test Case A
  2, 25, Test Case B
  3, 26, Test Case C
  
  Users
  user_id | user_email | user_company
  25, example-email-a, Company Alpha
  26, example-email-b, Company Beta
  27, example-email-c, Company Alpha
  </code></pre>
  
  <p>Many thanks</p>