I use this Query to get all my elements from `TABLE_LISTELEMENT` which dont have an entry in the column `COL_FK_RID`.

`db.rawQuery("SELECT * FROM " + TABLE_LISTELEMENT + " WHERE " + COL_FK_RID + " = ?", new String[]{"null"});`

Now I check my second table to get the `COL_RID`

`db.rawQuery("SELECT " + COL_RID + " FROM " + TABLE_ROOM + " WHERE "+ COL_RNAME + " = ?",new String[]{room}).toString();`

How do I insert the result of my second query in the `COL_FK_RID` column of my first table?