title: sqlite How do i select using results from another select?
body: <p>in SQLite with C# I want to do</p>
  
  <pre><code>SELECT * FROM media WHERE mediaId= for each
    SELECT mediaId FROM fav WHERE userId=1 ORDER BY indx DESC LIMIT 0, 100
  </code></pre>
  
  <p>The syntax is obviously incorrect. I have no idea how to use the param from one select statement in another.</p>