I have an app where I want to list all phone numbers and the associated contact name. I see that there is the Contacts.People table for the purpose of getting all phone numbers and that there is a PERSON_ID to allow me to lookup the contact in Contacts.People. Great.
The only problem is I can't figure out how to JOIN these tables. What I roughly want to do is this (in SQL): SELECT People.Phones._ID, People.NAME, People.Phones.NUMBER FROM Contacts.People.Phones INNER JOIN Contacts.People ON Contacts.People._ID=Contacts.People.Phones.PERSON_ID **Now I see that all the columns I want are already joined to the Contacts.People.Phones table. But that seems lucky in this case. How could I do the equivalent of the above statement in general if the implementer of the content provider hadn't been so nice as to join for me? Thanks in advance for any help. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
