title: SQL Update one table based on conditions in another table
body: <p>Two tables.</p>
  
  <pre><code>Content (table),
     topic_id (primary key),
     data (text)
  
  Topics (table),
     topic_id (primary key),
     content_type (text)
  </code></pre>
  
  <p>Both tables have the same primary key data (topic_id).</p>
  
  <p>I need to update the data field (Content table) with the text "disabled" but only where the content_type field (Topics table) = the text "rvf"</p>
  
  <p>I can: <code>SELECT * from topics WHERE content_type = "rvf";</code></p>
  
  <p>I can: <code>UPDATE content SET data = ("disabled");</code></p>
  
  <p>But how can I put those together.</p>