android sqlite union, how to retrive results from the tables?

I have this SQLite query:

Cursor orgiCursor = orgiDb.rawQuery("select task,taskDate from meeting where exists 
(select `meeting.taskId from Task, meeting where meeting.taskId = Task.taskId and task.name='"+profName+"')
UNION  SELECT subject,date from taskDeadline where exists (select taskDeadline.taskId from taskDeadline,Task where taskDeadline.taskId=Task.taskId and Task.name='"+profName+"') union select 
specificOccassion,setDate from AnnualTask where exists (select taskId from Task,AnnualTask where Task.taskId = AnnualTask.taskId and Task.name = '"+profName+"' and AnnualTask.setDate<>'--')", null);

It's quite long really, but it works flawlessly on SQLite Manager. My problem is that I get an error in retrieving the data. Here is a snippet of my code:

try {
    if (orgiCursor != null ) {
        if (orgiCursor.moveToFirst()) {
            do {
                String annualTask = orgiCursor.getString(orgiCursor.getColumnIndex("specificOccassion"));
                String annualDate = orgiCursor.getString(orgiCursor.getColumnIndex("setDate"));
                String meetingTask = orgiCursor.getString(orgiCursor.getColumnIndex("task"));
                String meetingDate = orgiCursor.getString(orgiCursor.getColumnIndex("taskDate"));
                String deadlineTask = orgiCursor.getString(orgiCursor.getColumnIndex("subject"));
                String deadlineDate = orgiCursor.getString(orgiCursor.getColumnIndex("date"));

                SearchResults sr2=new SearchResults();
                sr2.setName(meetingTask);
                sr2.settDate(meetingDate);
                results.add(sr2);

                SearchResults sr3 = new SearchResults();
                sr3.setName(deadlineTask);
                sr3.settDate(deadlineDate);
                results.add(sr3);

                SearchResults开发者_如何学JAVA sr1 = new SearchResults();
                sr1.setName(annualTask);
                sr1.settDate(annualDate);
                Log.i("Home","added"+annualTask + " & " +annualDate);
                results.add(sr1);
            } while (orgiCursor.moveToNext());
        }
    }
} catch (SQLiteException se) {
    displayError1(se.toString());
    Log.e(getClass().getSimpleName(), se.toString());
} finally {
    if (orgiDb != null) {
        orgiDb.close();
        Log.e(getClass().getSimpleName(),"orgiDB closed()");
    }
}


    return results;

It returns this error. :( Please help me.

02-12 19:28:00.809: INFO/Database(14515): sqlite returned: error code = 1, msg = ambiguous column name: taskId
02-12 19:28:00.849: ERROR/AndroidRuntime(14515): Caused by: android.database.sqlite.SQLiteException: ambiguous column name: taskId: , while compiling: select task,taskDate from meeting where exists (select meeting.taskId from Task, meeting where meeting.taskId = Task.taskId and task.name='Maria Ozawa')UNION  SELECT subject,date from taskDeadline where exists (select taskDeadline.taskId from taskDeadline,Task where taskDeadline.taskId=Task.taskId and Task.name='Maria Ozawa') union select specificOccassion,setDate from AnnualTask where exists (select taskId from Task,AnnualTask where Task.taskId = AnnualTask.taskId and Task.name = 'Maria Ozawa' and AnnualTask.setDate<>'--')

02-12 19:28:01.059: ERROR/Database(14515): close() was never explicitly called on database '/data/data/orgy.organizer.home/databases/orgi' 
02-12 19:28:01.059: ERROR/Database(14515): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here

Any help would be greatly appreciated... :( So my questions are:

1. Which part of the code do I exactly need to close the connection/cursor?

2. Why does Eclipse give me this error? I tried running this same statement in SQLite Manager and it gave me flawless results.

---

it seems the error is in the query, the fact it does not close the cursor is because he does not compute the query correctly i think

try to use alias when you use the attribute taskId, you use it many times and maybe it confuses the compiler

hope this helped!