title: SQLiteDatabase How to join two strings in SQLiteDatabase query and SimpleCursorAdapter?
body: <p><strong>Table fields:</strong> </p>
  
  <p>_id, street, house_nr</p>
  
  <p><strong>query:</strong></p>
  
  <pre><code>mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_STREET_NAME,
                  KEY_HOUSE_NUMBER}, null, null, null, null, KEY_ROWID + " DESC");
  </code></pre>
  
  <p><strong>SimpleCursorAdapter:</strong></p>
  
  <pre><code>    Cursor c = mDbHelper.fetchAllRows();
      startManagingCursor(c);
  
      String[] from = new String[] { HistoryDbAdapter.KEY_STREET_NAME};
      int[] to = new int[] { R.id.text1 };
  
      SimpleCursorAdapter entries =
          new SimpleCursorAdapter(this, R.layout.history_row, c, from, to);
      setListAdapter(entries);
  </code></pre>
  
  <p>How to add one combined string from two db fields into R.id.text1 to show full address.</p>
  
  <p><strong>example:</strong></p>
  
  <pre><code>street = "Android street"
  house_nr = "911"
  </code></pre>
  
  <p><strong>then:</strong></p>
  
  <pre><code>R.id.text1 = "Android street 911"
  </code></pre>
  
  <p>thanks</p>