I'm trying to extends the contacts by adding additional fields to contacts.people using in the contacts.extensions. My only problem is that have no ideea how to query the contacts.people using a join with contacts.extensions. I'm not trying to modify/extend the contacts provider.
One very very ugly solution would be to query on contacts.extensions and using the person ids to query the contacts.people (manual join) ... The idea is to create an ListActivity which displays the extended contacts (display name, picture) and also some fields from contacts.extensions.
I would like to be able to create a content provider that uses directly the contacts.db (from the content provider) where i could use my join queries... but from what I know this is not possible.
Do the content providers support joins? Or is there another way to create this kind of joins?