title: Update_all query with joins in rails console
body: <p>I have an trackers table and applications tables</p>
  
  <p>application.rb
  has_many :trackers</p>
  
  <p>tracker.rb</p>
  
  <p>belongs_to :application</p>
  
  <p>What I trying to do is update the check_in_date in the trackers table to be query to begin_date in the applications tables only for those records which have check_in_date is equal to "2019-05-30".</p>
  
  <p>I am trying to run the command below but I am getting an error.</p>
  
  <pre><code>Tracker.joins(:application).where("check_in_date = ?", "2019-05-30").update_all("tracker.check_in_date = application.begin_date")
  </code></pre>
  
  <p>error</p>
  
  <pre><code>ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR:  missing FROM-clause entry for table "application")
  </code></pre>
  
  <p>Any idea where i am going wrong.</p>