title: Laravel 5.2. DB table + Join with Update
body: <p>I need update key in table catalog and I write query (mysql query is right):</p>
  <pre><code>update attributes a inner join catalog c on a.parent_id = c.id set a.key = c.left_key
  </code></pre>
  <p>and with Laravel DB:</p>
  <pre><code>DB::table('attributes as a')
      -&gt;join(catalog as c', 'a.parent_id', '=', 'c.id')
      -&gt;update([ 'a.key' =&gt; 'c.left_key' ]);
  </code></pre>
  <p>It's right query, but DB::table ... make all key in table catalog to 0.
  I write</p>
  <pre><code>DB::statement('update attributes a inner join catalog c on a.parent_id = c.id set a.key = c.left_key;');
  </code></pre>
  <p>And it's work! But I don't understand why DB::table with join and update don't work</p>