title: MS SQL inner join to fill out same column names
body: <p>Hey all I have 2 tables that have the same data in them. Those tables are called <strong>TrainingCity</strong> and <strong>TrainingState</strong>.</p>
  
  <p>I am updating the row in the <strong>tEvents</strong> table with the users inputted data on the website form. However, <strong>tTRIP</strong> table attaches to the <em>already entered</em> data on the <strong>tEvents</strong> table.</p>
  
  <p>I am looking to grab just the <strong>TrainingCity</strong> and <strong>TrainingState</strong> values and <em>include them</em> in the update to the tEvents table of the same name columns.</p>
  
  <pre><code>SELECT 
      *, TT.TrainingCity, TT.TrainingState 
  FROM 
      tEvents AS TE
  INNER JOIN 
      tTRIP AS TT
  ON 
      TT.RequestID = TE.RequestID
  WHERE 
      TE.EventID = 12
  AND 
      TE.RequestID = 801
  </code></pre>
  
  <p>My update query looks like this:</p>
  
  <pre><code>command = new SqlCommand("UPDATE " +
                              "tEvents " +
                           "SET " +
                               buildTblVal +
                           " WHERE " +
                               "EventID = @eventID " + 
                           "AND " +
                               "RequestID = @reqID", con);
  </code></pre>
  
  <p>What would the query need to be modified too in order to grab those 2 values from the <strong>tTRIP</strong> table and place them into the <strong>tEvents</strong> table?</p>