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

2 votes261 views1 answer
Sql ignore accents
SQL
0 vote232 views1 answer
Query for maximum salary
SQL
5 votes282 views4 answers
Change auto increment mysql
SQL
0 vote278 views1 answer
How to find the most occuring in SQL
SQL
1 vote312 views1 answer
Sql select row with max date
SQL
0 vote282 views1 answer
Alter check command
SQL
1 vote319 views1 answer
Oracle drop temporary table
SQL
1 vote268 views1 answer
Set all the vluses in calumn in sql to false
SQL
7 votes281 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote270 views1 answer
How convert into in in sql query
SQL