Many of the standard providers use multiple tables. For example: http://android.git.kernel.org/?p=platform/packages/providers/ContactsProvider.git;a=blob;f=src/com/android/providers/contacts/ContactsProvider.java
On Wed, Oct 7, 2009 at 2:30 PM, Harshit Mapara <[email protected]> wrote: > > Actually I found one way. > > using SQLiteDatabase object you can call rawQuery() method and pass > the entire select query. > You can specify whatever you want (inner join, outer join,...) > > I tried this way and it worked. > > Thanks > > > On Oct 7, 8:06 am, Steve <[email protected]> wrote: > > Seems like you could do that. Have you tried setting up your content > > provider so that it does a query against multiple tables? > > > > The whole idea of content providers (other than exposing data across > > apps) is that the app requesting the data doesn't need to know > > anything about the complexity behind what is being done to collect the > > data. Your app might request a simple query, but your content > > provider is doing a lot of complicated work to collect that data. > > > > On Oct 6, 11:59 am, "Mapara,Harshit Nitinkumar" <[email protected]> > > wrote: > > > > > > > > > Hi > > > > > I want to operate on multiple tables. I searched a lot but everywhere > > > I could find is single table with one content provider. > > > > > How can I use multiple tables under one content provider? How can I > > > get result from two/three tables ? > > > > > Can I provide my own SQL select query from multiple tables in > > > ContentProvider? > > > > > Can anybody give me any example or link where I can get idea? > > > > > Thanks > > > Harshit > > > -- Dianne Hackborn Android framework engineer [email protected] Note: please don't send private questions to me, as I don't have time to provide private support, and so won't reply to such e-mails. All such questions should be posted on public forums, where I and others can see and answer them. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
