title: Teradata update join syntax
body: <p>I've tried a few examples I've seen on the internet, but I can't seem to figure them out.  This is a Teradata database.</p>
  
  <p>I have TableA that has CustomerId and DepartmentId.</p>
  
  <p>I have TableB that also CustomerId and DepartmentId.</p>
  
  <p>I know this structure is not practical, but this is a highly non-normalized database that we took over from an offshore development team and we have to work with what we have.</p>
  
  <p>What I want to do is join TableA and TableB on the CustomerId then set the DepartmentId of TableB to what's in TableA.  I would greatly appreciate the proper syntax.</p>