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

2 votes125 views4 answers
Mysql select into new table
SQL
1 vote121 views1 answer
Find logged in users mysql
SQL
1 vote138 views1 answer
Events mysql
SQL
0 vote127 views1 answer
Mysql 5.7 in centos 7
SQL
-1 vote148 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
1 vote122 views1 answer
Oracle undo usage per session
SQL
15 votes129 views2 answers
How to drop database name in postgresql
SQL
2 votes130 views1 answer
Date conversion in mysql column
SQL
1 vote119 views1 answer
Mysql check string don't have number
SQL
0 vote133 views1 answer
Mysql sum with group by
SQL