title: SQL Updating entire column based on Primary key from another table
body: <p>Example we have 2 tables:</p>
  <p>device_tb has columns &quot;device_num&quot; and &quot;device_name&quot;</p>
  <p>property_tb has columns &quot;id&quot; and &quot;item_name(currently null or placeholder values)&quot;</p>
  <p>device_tb.device_num is equal to the property_tb.id as in it lists the unique id of the product.</p>
  <p>If i want to update property_tb.item_name with the strings from device_name instead of manually keying in the names how would i go about it?</p>
  <p>Would this work?</p>
  <pre><code>UPDATE property_tb 
  SET item_name= device_tb.device_name
  WHERE property_tb.id = device_tb.device_num
  </code></pre>