title: Update the retrieve data from SQL Query that is in another table
body: <p>Hello Guys I am trying to retrieve data using this command:</p>
  
  <pre><code>SELECT TOP 1000 [TS]
        ,[Id]
        ,[Name]
        ,[Email]
   FROM [tblData].[dbo].[Info]
  </code></pre>
  
  <p>This gives me a results: </p>
  
  <pre><code>TS: QWRTY  
  ID: 191  
  Name: Henrol  
  Email: Email
  </code></pre>
  
  <p>I also have another tbl "tblNickName" where there is ID,Nickname column:</p>
  
  <pre><code>ID: 191  
  NickName: Henjoe
  </code></pre>
  
  <p>Now I want to change my retrieved data to be something like this:  </p>
  
  <pre><code>TS: QWRTY  
  ID: Henjoe  -- The ID now is changed to their nick name from another table.  
  Name: Henrol  
  Email: @email
  </code></pre>
  
  <p>I don't really search what would be the syntax/or right query to do it.
  Hope you help me. THanks !</p>