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

0 vote143 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
1 vote130 views1 answer
Where not in array sql
SQL
1 vote130 views1 answer
Sql delete all values in a column
SQL
0 vote128 views1 answer
Windows services sql
SQL
1 vote143 views1 answer
Add multiple row table pl sql
SQL
1 vote203 views1 answer
Oracle create program if not exists
SQL
2 votes174 views1 answer
Orcale index size
SQL
0 vote144 views1 answer
Helptext in sql
SQL
0 vote150 views1 answer
Add computed column to table sql server
SQL
0 vote138 views1 answer
Postgresql function ROUND
SQL