title: GROUP_CONCAT in SQLite
body: <p>I am having data like this</p>
  
  <pre><code>1 A
  1 B
  1 C
  1 D
  2 E
  2 F
  3 G
  3 H
  3 I
  3 J
  3 K
  </code></pre>
  
  <p>by using this query</p>
  
  <pre><code>select ABSTRACTS_ITEM._id,Name 
  from ABSTRACTS_ITEM , ABSTRACT_AUTHOR , AUTHORS_ABSTRACT
  where
  ABSTRACTS_ITEM._id = AUTHORS_ABSTRACT.ABSTRACTSITEM_ID
  and
  ABSTRACT_AUTHOR._id = AUTHORS_ABSTRACT.ABSTRACTAUTHOR_ID
  </code></pre>
  
  <p>Now, I want to show data like this</p>
  
  <pre><code>1 A,B,C,D
  2 EF
  </code></pre>
  
  <p>and so on..I also know it can achieve by <code>GROUP_CONCAT</code> function. So, I tried with this</p>
  
  <pre><code>SELECT ABSTRACTS_ITEM._id,
  GROUP_CONCAT(ABSTRACT_AUTHOR.NAME) FROM
  (select ABSTRACTS_ITEM._id,
  Name
  from
  ABSTRACTS_ITEM , ABSTRACT_AUTHOR , AUTHORS_ABSTRACT
  where
  ABSTRACTS_ITEM._id = AUTHORS_ABSTRACT.ABSTRACTSITEM_ID
  and
  ABSTRACT_AUTHOR._id = AUTHORS_ABSTRACT.ABSTRACTAUTHOR_ID)
  </code></pre>
  
  <p>But, It shows me error. So, what I am doing wrong here. What are the right procedure to achieve that?</p>