title: Use Select to Join two tables, Show only a few columns and also have a between criteria
body: <p>I googled and searched this place but not an answer I could Find because what others have was different. </p>
  
  <pre><code>USE TestDatabase
  Select Firstname,Lastname,Salary From Employee as E 
  Join JobTitle as J
  on E.JobTitleID = J.JobTitleID
  
  WHERE Salary 
  BETWEEN $25000.00 AND $50000.00
  </code></pre>
  
  <p>This works but I am trying to show two columns from JobTitle Table and I don't either know what words to search or Google and can't not find a simple answer. Can anyone help must be simple for some but I am confused. I am using server 2008 t-sql for school</p>