I have a sqlite database in android , for example :

Table 1 person: 

* column 1: id
* column 2: name
* column 3: friends

Table 2 friends:

* column 1: id
* column 2: allFriends

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.