android -从Android游标中的子查询中获得结果？

Question

我有一个subquery sqlite：

SELECT BookDB.ArticleID,BookDB.Title, subquery.Title FROM BookDB, (SELECT 
MetaDataID,Title  FROM MetaDataDB  order by OrderView) subquery WHERE 
subquery.MetaDataID = BookDB.ArticleID;

这个query给我的结果(在编辑器sqlite)，但我看不到任何结果在cursor的安卓。

cursor = sql.rawQuery("SELECT BookDB.ArticleID,BookDB.Title, subquery.Title FROM BookDB, (SELECT 
MetaDataID,Title  FROM MetaDataDB  order by OrderView) subquery WHERE 
subquery.MetaDataID = BookDB.ArticleID;", null);
                    if (cursor != null) {
                        do {
                            cursor.moveToFirst();
                            String C = cursor.getString(cursor.getColumnIndex("BookDB.Title"));
                            Log.i("results",C);
                        } while (cursor.moveToNext());
                    }

注:我怎样才能从这一行得到结果？

String C = cursor.getString(cursor.getColumnIndex("BookDB.Title"));

Answer 1

我改变了我的Query，它起了作用：

cursor = sql.rawQuery("SELECT BookDB.ArticleID as ID,BookDB.Title as TITLE, subquery.Title as COMM FROM BookDB, (SELECT 
MetaDataID,Title  FROM MetaDataDB  order by OrderView) subquery WHERE 
subquery.MetaDataID = BookDB.ArticleID;", null);
                    if (cursor != null) {
                        do {
                            cursor.moveToFirst();
                            String C = cursor.getString(cursor.getColumnIndex("TITLE"));
                            Log.i("results",C);
                        } while (cursor.moveToNext());
                    }

现在就给我结果。