title: Get additional columns when grouping
body: <p>I am trying to add one more column into this search, but it brings make multiple lines when I add the next column</p>
  
  <p>The code below brings back the correct information, but I need the column named category without bringing back multiple rows for each bus</p>
  
  <pre><code>SELECT workorders.bus, MAX(workorders.service_date) AS ServiceDate
    , MAX (workorders.mileage) AS Mileage
  FROM dbo.WorkOrders 
  WHERE (workorders.type = 'PMI') 
  GROUP BY workorders.bus
  order by workorders.bus
  
  bus ServiceDate Mileage
  108 2017-05-14  347480
  120 2014-07-11  167900
  545 2017-03-13  280659
  546 2017-03-13  293888
  547 2015-05-12  249017
  558 2019-06-24  376046
  </code></pre>
  
  <p>I expect to see a category next to each of these mileages, like A on the first return from bus 108. But, when I add the category to the search, then I get five bus 108s.</p>