title: How to display output when the Inner Select Query returns multiple values?
body: <p>The inner Select returns multiple values which I am not able to display and getting error. The first select has multiple columns wherein one of the column values are fetched through an inner query which returns multiple values. I want all the inner select values.</p>
  
  <pre><code> select t.SiteId, t.Name, t.IsHoliday, t.DateStart, t.DateEnd, t.Year,
      (
      select count(te.Name), te.Name
      from Term te
      inner join Site_Program_Term spt on te.Id = spt.TermId
      where te.Year = 2015 and te.SiteId = 2
      group by te.Name
      ) from Term t where t.SiteId=2 and t.year=2015
  </code></pre>