title: select statement for specific value sqlite
body: <p>could you help me to make a select query for this case, </p>
  
  <p>recently i'm looking for a way to implement expandable list view that fill the data from database, but i'm not found a proper example yet, 
  and this i'm thinking about another way,</p>
  
  <p>i have 2 table :</p>
  
  <p><strong>table1 :</strong></p>
  
  <pre><code>   +------------+----------+
     | id_table1  |  Item    | 
     +------------+----------+
     | 1          | Item1    |
     | 2          | Item2    |
     | 3          | Item3    |
     | 4          | Item2.1  |
     | 5          | Item2.2  |
     | 6          | Item3.1  |
     | 7          | Item3.2  |
     +------------+----------+
  </code></pre>
  
  <p><strong>table 2 :</strong> <code>id_table2.table2 = id_table1.table1 and table2.id_table = id_table1.table1</code></p>
  
  <pre><code>   +------------+----------+
     | id_table2  | id_table | 
     +------------+----------+
     | 2          | 4        |
     | 2          | 5        |
     | 3          | 6        |
     | 3          | 7        |
     +------------+----------+
  </code></pre>
  
  <p>and with some select query the result will be :</p>
  
  <pre><code>   Item1
     Item2
       Item2.1    //with space
       Item2.2    //with space
     Item3
       Item3.1    //with space
       Item3.2    //with space
  </code></pre>