title: Column '_id' does not exist SimpleCursorAdapter revisited
body: <p>I want to use the SimpleCursorAdapter to fill in my ListActivity, but I'm getting the classic exception because there is no '_id' field in my Cursor.  Unfortunately, this type of query does not provide me with a field that I can use as my _id field being of the form:</p>
  
  <pre><code>SELECT DISTINCT room from tblRates WHERE resid='ABC' AND date='2011-10-17'
  </code></pre>
  
  <p>Because of the DISTINCT I can't just add in the _id.  So what do I do short of setting up a custom Adapter?</p>
  
  <p>Btw, I have seen this post already so I do understand why I'm getting the error.  Just wondering how to get an _id in there with the type of query I'm doing:</p>
  
  <p><a href="https://stackoverflow.com/questions/3359414/android-column-id-does-not-exist">Android column &#39;_id&#39; does not exist?</a> </p>