android sqlite query join

1Cursor cursor = db.query(NoteContract.Note.TABLE_NAME 
2+ " LEFT OUTER JOIN authors ON notes._id=authors.note_id", projection, selection, 
3selectionArgs, null, null, "notes._id");
4

1private static final String TASK_TABLE_CREATE = "create table "
2        + TASK_TABLE + " (" 
3        + TASK_ID + " integer primary key autoincrement, " 
4        + TASK_TITLE + " text not null, " 
5        + TASK_NOTES + " text not null, "
6        + TASK_DATE_TIME + " text not null,"
7        + TASK_CAT + " integer,"
8        + " FOREIGN KEY ("+TASK_CAT+") REFERENCES "+CAT_TABLE+"("+CAT_ID+"));";
9