Android sqlite query join

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

Source: stackoverflow.com

Android sqlite query con join

private static final String TASK_TABLE_CREATE = "create table "
        + TASK_TABLE + " (" 
        + TASK_ID + " integer primary key autoincrement, " 
        + TASK_TITLE + " text not null, " 
        + TASK_NOTES + " text not null, "
        + TASK_DATE_TIME + " text not null,"
        + TASK_CAT + " integer,"
        + " FOREIGN KEY ("+TASK_CAT+") REFERENCES "+CAT_TABLE+"("+CAT_ID+"));";

Source: stackoverflow.com

Similar codes

3 votes184 views2 answers
Get current year sql
SQL
4 votes207 views1 answer
Ms sql truncate table vs delete
SQL
0 vote230 views1 answer
Install squirrel sql ubuntu
SQL
0 vote206 views1 answer
Pgadmin save data greyed out
SQL
0 vote174 views1 answer
What are the aggregate function in sql
SQL
0 vote152 views1 answer
Oracle sql replace string in clob
SQL
0 vote169 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote177 views1 answer
Fill up postgres db
SQL
0 vote191 views1 answer
Sqlite explain plan
SQL
3 votes194 views2 answers
Host is not allowed to connect to this mysql server
SQL