title: SQL, GROUP BY and INNER JOIN
body: <p>In addition to this question: <a href="https://stackoverflow.com/questions/10460755/comparing-in-sql-and-sum">Comparing in SQL and SUM</a></p>
  
  <p>I need some more help. At this point I have a View (lets call it inner-join-view) that joines two tables with an INNER JOIN. This is fine. Then I have another view which uses SUM+GROUP BY to sum up some data from the inner-join-view, which is fine. Now, however, I need data from the inner-join-view that doesn't have anything to do with the group by. Does that make sense? I can't just select it and then group it, because that creates a wrong calculation.</p>
  
  <p>How can I come around this?</p>