But how about ContentProvider? I didn't query database directly, I used ContentProvider.
On 10月16日, 下午6時39分, RichardC <[email protected]> wrote: > You can use a JOIN clause in SQLiteQueryBuilder.setTables > > http://developer.android.com/reference/android/database/sqlite/SQLite... > > -- > RichardC > > On Oct 16, 10:50 am, Victor Lin <[email protected]> wrote: > > > Hi, I have two tables: > > > Category(_id, name) > > Spend(_id, spend, category_id) > > > I want to join these two tables. I tried to use CursorJoiner: > > > Cursor spendCursor = managedQuery( > > AccountBook.Spend.CONTENT_URI, > > new String[] { AccountBook.Spend._ID, > > AccountBook.Spend.SPEND, AccountBook.Spend.CATEGORY_ID }, > > null, null, AccountBook.Spend.CATEGORY_ID > > ); > > > Cursor categoryCursor = managedQuery( > > AccountBook.Category.CONTENT_URI, > > new String[] { AccountBook.Category._ID, > > AccountBook.Category.NAME }, > > null, null, AccountBook.Category._ID > > ); > > > CursorJoiner joiner = new CursorJoiner( > > spendCursor, new String[] { AccountBook.Spend.CATEGORY_ID }, > > categoryCursor, new String[] { AccountBook.Category._ID } > > ); > > > With following data: > > > Spend's category_id: 1, 1, 1, 1, 2 > > Category's _id: 1, 2, 3 > > > I got following results of CursorJoiner : > > > BOTH > > LEFT > > LEFT > > LEFT > > BOTH > > RIGHT > > > That's strange, it seems the behavior of CursorJoiner is not like the > > behavior of join of usual database. What I want is, list all spends in > > list with its category's name. > > > For example: > > > Spends (_id, spends, category_id) : > > 1, 999, 1 > > 2, 55, 2 > > 3, 30, 2 > > 4,, 60, 3 > > > Categories (_id, name): > > 1, food > > 2. tips > > 3. 3C products > > > And I want the list looks like: > > > (spend.spend, category.name) > > 999, food > > 55, tips > > 30, tips > > 60, 3C products > > > How can I achieve this with Android? > > > Thanks. > > Victor Lin. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
