sqlite database android get all column values into string array
<p>I have a sqlite  database in android , for example :</p>

<p>Table 1 person: </p>

<ul>
<li>column 1: id</li>
<li>column 2: name </li>
<li>column 3: friends</li>
</ul>

<p>Table 2 friends:</p>

<ul>
<li>column 1: id</li>
<li>column 2: allFriends</li>
</ul>

<p>the id is the same in  both tables,  id in table1 == id in table2
i want to get all the values from table2 in specific column "allFriends" by the id and insert all the String values from the column into String array / arrayList.</p>