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

3 votes310 views3 answers
How to add month in update sql
SQL
9 votes294 views3 answers
Sequence postgresql
SQL
1 vote311 views4 answers
Sql now
SQL
3 votes326 views1 answer
Sql add two values together
SQL
0 vote314 views1 answer
How to get data from 2 database
SQL
4 votes292 views1 answer
Mysql biginteger size
SQL
0 vote303 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote300 views1 answer
Postgresql array to rows
SQL
23 votes318 views2 answers
Query to delete a database in mysql
SQL
0 vote306 views2 answers
How to know the character set of an oracle databes
SQL