title: Update two columns in sql
body: <p>This is the table of data that I need to change.</p>
  
  <pre><code>SELECT appId, categoryID, categoryName, classdesc
  FROM apps JOIN appsCategories USING(appID)
  JOIN categories USING (categoryID)
  JOIN classes USING (classID)
  WHERE classDesc = "Auto"
  </code></pre>
  
  <p>which returns something like this:</p>
  
  <pre><code>appid         categoryID         categoryName        classDesc
  
  400           100                Public              AUTO
  405           101                Business            AUTO
  410           102                Auto                AUTO
  415           102                Auto                AUTO
  </code></pre>
  
  <p>I want to update my table so that all data below is updated to have a categoryName of Auto with the categoryID of 102. I need to use the Select statement above somehow but am unsure how to update both columns. Any help is greatly appreciated!</p>