title: Android: How to access results from Cursor when INNER JOIN is performed?
body: <p>I am using INNER JOIN on two tables,table1 and table2, from my SQLite Database.
  How do I access the results(columns of both tables) from the cursor? The two tables have 2 columns with same name.</p>
  
  <pre><code>        String query = SELECT * FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE name like '%c%';
          Cursor c = newDB.rawQuery(query, null);
  </code></pre>