title: Return item from another table in SQL
body: <p>I am struggling to get this one to work!! i know its simple...</p>
  
  <p>I have a table full of jobs, and a table containing locations (in order that new locations can be added dynamically and populate dropdowns etc.</p>
  
  <p>What I want to do it return all jobs at one location (not a problem) they are assigned a location ID that corresponds with an ID per location (which contains job_location_ID, job_Location_name, job_Location_Country)</p>
  
  <pre><code>sql = "SELECT  [job_ID],
          [job_ref],
          [job_title],
          [job_description],
          [job_location]
  FROM    [Web_Xtr_HR]
  WHERE   (
            ( [job_ext_int_both] = 1 )
            AND ( [job_location] = " + theIndex + " )
          )
  ORDER BY [job_ID] DESC"
  </code></pre>
  
  <p>This reads all the items in, so what i need to do, per result is include the job_Location_name that is associated, with the job_Location_ID in the other table ([Web_Xtr_Job_Locations])</p>
  
  <p>help!</p>