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

1 vote105 views1 answer
Sql order by where condition
SQL
4 votes98 views6 answers
Sql select statement
SQL
0 vote109 views1 answer
Check if database exists sql
SQL
0 vote59 views1 answer
Copy data from cell to cell mysql
SQL
0 vote106 views1 answer
Test the postgresql db connection
SQL
36 votes230 views6 answers
Change column data type sql
SQL
0 vote101 views1 answer
Mysql create table like
SQL
0 vote111 views1 answer
Every Derived yable must have its own alias
SQL
0 vote110 views1 answer
Sql server Cost Fifo query
SQL
0 vote133 views1 answer
Mysql relationships between tables
SQL