title: Core Data. Is it possible creating a view like you would do with normal SQL
body: <p>In normal SQL world you would use Create View .... to define a view on one or more tables, e.g. to get a join and already a group by. Is that also possible somehow in Core data?</p>
  
  <p>The reason I'm asking is, I have a table with a details. Each detail record has two keys and an amount. Now I need to show the sum of the amounts grouped by the two keys in a table view - i.e. The first key in the section and the second as normal entry with the sum amount. I thought FRC would work, but it does not group (add up the detail records). With a normal fetch request I can group and get everything - but it seems to be a lot of work to handle the sections manual. So I thought, the best is, I put a view on the table and use the FRC to bring it in the table view. Does that make sense? Any help ist very much appreciated. </p>
  
  <p>example:</p>
  
  <pre><code>I have three fields:
  A X  2
  A X  2
  A Z  3
  B X  2
  B Y  2
  B Y  1
  B Z  8
  </code></pre>
  
  <p>as a result I need</p>
  
  <pre><code> Section : A
   X 4
   Z 3
   Section: B
   Y 2
   Z 8
  </code></pre>