title: How to left outer joins with conditions
body: <p>I have this relation:</p>
  
  <pre><code>class Action &lt; ApplicationRecord
     has_many :actions_users
  </code></pre>
  
  <p>I tried to make a query like:</p>
  
  <pre><code>select *
  from actions left outer join actions_users
  on actions_users.action_id = actions.id and actions_users.user_id = 1
  where actions.user_id = 1
  </code></pre>
  
  <p>Meanwhile, in my experience, in all of the result that I tried,</p>
  
  <pre><code>select *
  from actions left outer join actions_users
  on actions_users.action_id = actions.id
  where actions.user_id = 1 and actions_users.user_id = 1 
  </code></pre>
  
  <p>the join condition code and general condition are in <code>where</code> function.</p>
  
  <p>How can I work it out?</p>