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

6 votes214 views1 answer
Oracle rank
SQL
5 votes162 views1 answer
Copy table from one database to another mysql
SQL
0 vote209 views1 answer
Get role postgres
SQL
13 votes213 views4 answers
What is sql
SQL
2 votes216 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote195 views1 answer
What is the difference between now() and current_date()?
SQL
10 votes193 views1 answer
Oracle view dependencies
SQL
0 vote279 views1 answer
Opensuse start MySQL
SQL
5 votes272 views3 answers
Create function in postgresql
SQL
0 vote193 views1 answer
Replace multiple string in query sql
SQL