title: Nested query is not supported in SQLite
body: <p>I use an SQLite database on my iPhone application and i need to perform a task that require a nested query. However, my query seems not working, i have googled it and i found that SQLite doesn't support Subquerys.
  Is there any solution?</p>
  
  <p><strong>EDIT:</strong>
  This is the query that doesn't work for me:</p>
  
  <pre><code>select count(*) from quiz where theme=(select id from theme where nom="Houses") and etat=0;
  </code></pre>