How do I join two SQLite tables in my Android application?

by

You need rawQuery method.

Example:

private final String MY_QUERY = "SELECT * FROM table_a a INNER JOIN table_b b ON a.id=b.other_id WHERE b.property_id=?";

db.rawQuery(MY_QUERY, new String[]{String.valueOf(propertyId)});

Use ? bindings instead of putting values into raw sql query.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. IN clause and placeholders
  4. Android Database Transaction
  5. How can I create a user-defined function in SQLite?
  6. SQLiteDatabase.query method
  7. About “_id” field in Android SQLite
  8. Import .csv file to Sqlite in Android
  9. Debugging sqlite database on the device
  10. SQLite Android Database Cursor window allocation of 2048 kb failed
  11. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  12. Android SQLite: Update Statement
  13. Bulk Insertion on Android device
  14. Android Sqlite selection args[] with int values
  15. SQLite simultaneous reading and writing
  16. update sql database with ContentValues and the update-method
  17. SQLiteDatabase close() function causing NullPointerException when multiple threads
  18. Using the LIMIT statement in a SQLite query
  19. sqlite encryption for android
  20. Android quotes within an sql query string
  21. Retrieve large blob from Android sqlite database
  22. Android SQLite rawquery parameters
  23. Saving ArrayLists in SQLite databases
  24. How to convert milliseconds to date in SQLite
  25. DB File in Assets Folder. Will it be Updated?
  26. Backup/restore sqlite db in android [duplicate]
  27. How to store JSON object in SQLite database
  28. Android SQLiteOpenHelper cannot open database file
  29. Android table creation Failure (near “autoincrement”: syntax error)?
  30. sqlite insert into table select * from

Leave a Comment