title: Join in sqlite Android
body: <p>I have two tables in my database table1, table2. I have a join query like this:</p>
  
  <pre><code>select a.*,b.* from table1 a,table2 b where a.field1=b.field1;
  </code></pre>
  
  <p>Its working fine while i test it in sqlite manager(sqlite browser). when i try to make it through java like this:</p>
  
  <pre><code> database.execSQL("select a.*,b.* from table1 a,table2 b where a.field1=b.field1;");
  </code></pre>
  
  <p>its saying <code>return type</code> is not <code>cursor</code>. How can i get it to cursor with join. I have to get that data and show in a <code>listview</code></p>