Actually I guess the table to use is Contacts.Phones but the question still stands.
On Aug 28, 1:38 pm, eags <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
