Android: ListView using two cursoradapters?

Question

I have some code which executes two queries against a database and returns two cursor objects. Is there any way that I can combine these two cursors so that all the ListView gets the data from both?

Answer 1

Check out MatrixCursor.

Maybe this will help you also Android - Database Table Join

Answer 2

You can also use cwac-merge.

cwac-merge: Provides the MergeAdapter, a ListAdapter that blends multiple Views or ListAdapters into a single ListAdapter. Use this for section headings, blending multiple sources of data together, etc.

Answer 3

There's MergeCursor for that (if there's no way to join tables).