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

15 votes201 views2 answers
Select where duplicate mysql
SQL
3 votes150 views2 answers
Mysql sum with condition
SQL
0 vote194 views1 answer
Mysql Digital Ocean connection problems
SQL
25 votes202 views3 answers
How to use a database to see tables mysql
SQL
11 votes202 views2 answers
How to import mysql database command line
SQL
-1 vote149 views3 answers
Ubuntu install mssql
SQL
0 vote197 views1 answer
Sql server concat null
SQL
0 vote175 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote210 views4 answers
What is unique key in sql
SQL
19 votes221 views5 answers
Display table in sql
SQL