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

0 vote150 views1 answer
Sql select all tables from database change url
SQL
6 votes246 views2 answers
Database url postgres
SQL
8 votes148 views5 answers
Alter table add column with default value
SQL
1 vote178 views1 answer
Oracle repeat_interval 5 minutes
SQL
1 vote158 views1 answer
Age postgres
SQL
0 vote154 views1 answer
Creation d'un trigger sql
SQL
0 vote168 views1 answer
Declaring variables in pl sql
SQL
0 vote146 views1 answer
Oracle sql winter time change
SQL
0 vote185 views1 answer
Mysl like insert a variable
SQL
1 vote173 views1 answer
Create index concurrently postgres
SQL