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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to