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 vote344 views2 answers
Mysql on update current_timestamp
SQL
0 vote348 views1 answer
SQL query to verify the size of the table
SQL
0 vote322 views1 answer
Get week day name sql server
SQL
0 vote346 views1 answer
Get id if is not equal in certain table
SQL
0 vote329 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote329 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
9 votes344 views5 answers
Laravel to sql
SQL
0 vote324 views1 answer
Sqlalchemy get ids
SQL
1 vote379 views1 answer
Delete dublicate rows sql
SQL
13 votes333 views6 answers
Mysql update from select
SQL