title: Combine Room and Content Resolver data into one object
body: <p>My app supports adding contacts to a note.</p>
  
  <p>In this process, I'm storing a <code>Contact</code> entity in my apps database, where I primarily use the <code>contactId</code> to identify the contact.</p>
  
  <p>In my UI, the name should be displayed, too. Therefore, I'm looking for a possibility to create a combined query (like a <code>INNER JOIN</code>) for fetching my apps contact data together with the name of the contact from the device's address book.</p>
  
  <p>Is this possible?</p>
  
  <p>My contact entity:</p>
  
  <pre><code>data class Contact(
      @PrimaryKey(autoGenerate = true) @ColumnInfo(name = Database.Contacts.COL_ID) val id: Long,
      @ColumnInfo(name = Database.Contacts.COL_CONTACT_ID) val contactId: Long,
      /* This should be fetched from the content provider. */ val contactName: String,
      @ColumnInfo(name = Database.Contacts.COL_TRANSACTION_ID) val transactionId: Long
  ) : Model
  </code></pre>
  
  <p>Thank you!</p>