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 vote315 views1 answer
Sql case sttement with set
SQL
0 vote300 views1 answer
First mysql
SQL
1 vote330 views1 answer
Round function in sql oracle
SQL
0 vote334 views1 answer
Groupby sort sql hive
SQL
0 vote313 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote325 views1 answer
What alter does in db
SQL
1 vote293 views1 answer
Mysql average of multiple columns
SQL
12 votes326 views4 answers
How to take database dump in postgresql
SQL
10 votes305 views2 answers
Reset mysql root password mac
SQL
11 votes322 views1 answer
Oracle insert into where
SQL