title: How do I do a Left join in a rails find
body: <p>I have this </p>
  
  <pre><code>User.joins(:notifications).joins(:company_users).joins(:role_users).where("notifications.id = ? AND role_users.role_id != '1' AND (company_users.company_id = ? OR users.company_id = ?)", notification.id, p.company_id, p.company_id)
  </code></pre>
  
  <p>=> [] </p>
  
  <p>which produces this sql</p>
  
  <pre><code>SELECT `users`.* FROM `users` 
  INNER JOIN `subscriptions` ON `users`.`id` = `subscriptions`.`user_id` 
  INNER JOIN `notifications` ON `notifications`.`id` = `subscriptions`.`notification_id` 
  INNER JOIN `company_users` ON `company_users`.`user_id` = `users`.`id` 
  INNER JOIN `role_users` ON `role_users`.`user_id` = `users`.`id` 
  WHERE (notifications.id = 1 
  AND role_users.role_id != '1' 
  AND (company_users.compcany_id = 67 OR users.company_id = 67))
  </code></pre>
  
  <p>the problem is I need to left join on company_users and not sure how to achieve that in rails</p>
  
  <p>I know I can do this with find_by_sql by i heard thats not really rails like....any ideas</p>