title: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. (I am Using sub query as column expression.)
body: <pre><code>Select e.first_name+' '+e.last_name As FullName, j.job_title, 
  (
      Select Max(start_date) As StartDate, Max(end_date) As EndDate
      From job_history as jh1
      Where jh1.employee_id = e.employee_id
      Group by employee_id
  )    
  From employees e, jobs j
  Where e.job_id = j.job_id
  And e.commission_pct = 0;
      
      
  </code></pre>
  <p>I would like to return the last job starting and ending dates of some employees. who don't get commissions and name (From employees
  table) and job_title (From jobs table). If a sub query is used as a
  column can't we have more than single column in it?</p>