title: android sqlite subquery for getting filtered data
body: <p>How can I execute a subquery in an SQLite database for Android using the rawquery function to retreive the data from the database.</p>
  
  <p>I want to execute query like below:</p>
  
  <pre><code>select * from table1 where id not in (select id from table2)
  </code></pre>