title: Replace Text of a field from a different table in SQL
body: <p>I have two data buckets using a cryptic naming convention.</p>
  
  <p>Am I able to update the data in the fields on the main table where the record entry is equal to the primary key on the other table?</p>
  
  <p>Something like Table1 has 5 columns, t1A t1B t1C t1D t1E
  and Table2 has 2 columns description, and Table1code.</p>
  
  <p>Am I able to switch the data in Table1 with the description field in Table2?</p>
  
  <p>I have tried doing a sql update/case statement but kept getting non-boolean errors when I would run it.</p>
  
  <p>Any help would be appreciated.</p>