title: Update database table from one SQL Server database table to another?
body: <p>I am trying to update database fields from one SQL Server table to another.</p>
  
  <p>Our production SQL Server is <code>[spdbprod.test.com\spprod]</code>, our QA server is <code>[spdbQA.test.com\spQA]</code>.</p>
  
  <p>I need to update table in production from QA table. I using this SQL statement but, it is giving an error. </p>
  
  <pre><code>UPDATE 
      [spdbprod.test.com\spprod].[aspnetdb].[dbo].[Communities_Groups] as t1
  SET 
      t1.Show = (Select t2.show from [spdbQA.test.com\spQA].[aspnetdb].[dbo].
  [Communities_Groups] as t2 where t1.GroupID = t2.GroupdID)
  </code></pre>
  
  <p>What I am missing here?
  <strong>Error:
  UPDATE. ("Incorrect syntax near the keyword 'as'.")</strong></p>