title: Joining two tables with specific columns
body: <p>I am new to SQL, I know this is really basic but I really do not know how to do it!
  I am joining two tables, each tables lets say has 5 columns, joining them will give me 10 columns in total which I really do not want. What I want is to select specific columns from both of the tables so that they only show after the join. (I want to reduce my joining result to specific columns only)</p>
  
  <pre><code>SELECT * FROM tbEmployees
  
  JOIN tbSupervisor
  
  ON tbEmployees.ID = tbSupervisor.SupervisorID
  </code></pre>
  
  <p>The syntax above will give me all columns which I don't want. I just want EmpName, Address from the tblEmployees table and Name, Address, project from the tbSupervisor table</p>
  
  <p>I know this step:</p>
  
  <pre><code>SELECT EmpName, Address FROM tbEmployees
  
  JOIN tbSupervisor
  
  ON tbEmployees.ID = tbSupervisor.SupervisorID
  </code></pre>
  
  <p>but I am not sure about the supervisor table.</p>
  
  <p>I am using SQL Server. </p>