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 vote109 views2 answers
Nosqlbooster query other collection
SQL
5 votes136 views1 answer
Purge undo tablespace usage
SQL
8 votes127 views1 answer
Mac restore mysql database command line
SQL
10 votes115 views1 answer
Oracle object dependencies
SQL
0 vote116 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote131 views1 answer
Delet all record statment sql
SQL
-2 votes169 views1 answer
Trunc in sql
SQL
1 vote126 views1 answer
Postgresql how to show table names
SQL
0 vote116 views1 answer
How much table store postgres
SQL
0 vote194 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL