title: Expression not in aggregate or GROUP BY columns Exception
body: <p>I have a table in <code>MS-Access</code> database named <code>ItemRates</code> which contains columns <code>ItemID, ItemName, TotalFeet, RatePerItem, TotalRate</code> and this database is connected with my <code>java</code> application.</p>
  
  <p>When i run the following query</p>
  
  <pre><code>String sql = "SELECT SUM(TotalRate) AS ItemRateSum, TotalFeet FROM ItemRates";
  </code></pre>
  
  <p>I get the following exception</p>
  
  <pre><code>net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.7 expression not in aggregate or
  GROUP BY columns: PUBLIC.ITEMRATES.TOTALFEET
  </code></pre>
  
  <p>I have seen other questions related to this exception on <code>StackOverflow</code> and one accepted answer suggested to add <code>GroupBy</code> clause at the end of the query. I added a <code>GroupBy</code> clause </p>
  
  <pre><code>String sql = "SELECT SUM(TotalRate) AS ItemRateSum, TotalFeet FROM 
  ItemRates GROUPBY ItemName";
  </code></pre>
  
  <p>and i got almost same exception (there's a slight difference between two exceptions at the end after the colon)</p>
  
  <pre><code>net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.7 expression not in aggregate or 
  GROUP BY columns: GROUPBY.TOTALFEET
  </code></pre>
  
  <p>What am i doing wrong here ?</p>