title: copy column value from one database.table to another database.table
body: <p>Let's keep it short and sweet</p>
  
  <p>I want to do this (I've failed numerous times now, and one attempt even updated the Row with blanks):</p>
  
  <pre><code>UPDATE Database2.Table1 
  SET (Database2.Table1.Column1, Database2.Table1.Column2, Database2.Table1.Column3) 
  VALUES 
     (Database1.Table1.Column1, Database1.Table1.Column2, Database1.Table1.Column3)
  WHERE Database2.Table1.Column1 = Database1.Table1.Column1
  </code></pre>
  
  <p>These two already contain the same value, but the other 2 columns do not, and that is what I wish to change with this query..</p>
  
  <p>Here's how each table look:</p>
  
  <p><strong>Database1.Table1</strong></p>
  
  <pre><code>[id]
  [name]
  [applicationdate]
  [startdate]
  [shortdescription]
  [longdescription]
  [displayimg]
  [contact]
  [website]
  [created]
  [urlbase]
  [site]
  [keywords]
  [type]
  [location]
  </code></pre>
  
  <p><strong>Database2.Table1</strong></p>
  
  <pre><code>[id]
  [name]
  [applicationdate]
  [startdate]
  [content]
  [keywords]
  [customerid]
  [urlbase]
  [shortdescription]
  [meta]
  [type]
  [site]
  [searchurlbase]
  [lang]
  [educationlength]
  [locations]
  [educationwebsite]
  [contact]
  [tags]
  [educationtypes]
  [created]
  [category]
  </code></pre>
  
  <p>Any help is greatly appreciated, thank you for your time :)</p>
  
  <p>Sorry if it doesn't make any sense, I easily get confused when trying to explain problems I'm having</p>