title: SQL select for Android AlterDialog displaying code/key values
body: <p>I'm ok with SQL but this one has me stumped. I'm about to give up on this but figured I'd post the question since other developers may find themselves looking for the same approach. </p>
  
  <p>I'm working on an android multiselect AlertDialog. The dialog will be used to select values from key/code tables. In order to get this to work I need a query that returns a result set which has all of the key/code id's and values and another column with a boolean (or +1 and -1) indicating if the given person has that title. Here's the result set I need (using SQLite 3):</p>
  
  <p>Given person.id = 1</p>
  
  <pre><code>TITLE.ID    TITLE.TITLE    PERSON_HAS_TITLE  
  1           Parent         true OR +1
  2           Teacher        true OR +1
  3           Fireman        false OR -1
  4           Policeman      false OR -1   
  
  
  **PERSON**  
  ID    NAME  
  1     Sue  
  2     Scott  
  3     Jim  
  
  **TITLE**   
  ID    TITLE  
  1     Parent  
  2     Teacher  
  3     Fireman  
  4     Policeman
  
  **PERSON_TITLE**  
  PERSON_ID   TITLE_ID  
  1           1  
  1           2  
  2           4 
  </code></pre>
  
  <p>Any ideas?</p>