joining two tables in android sqlite

Question

how to join in android database sqlite

`android.database.sqlite.SQLiteException: RIGHT and FULL OUTER JOINs are not currently supported` this more clearly tells you,what is it thats not understandable ?? — Rat-a-tat-a-tat Ratatouille, Apr 04 '14 at 04:22
possible duplicate of [What joins does SQLite support?](http://stackoverflow.com/questions/774475/what-joins-does-sqlite-support) — enrico.bacis, Aug 27 '14 at 08:51

score 0 · Answer 1 · answered Apr 04 '14 at 03:57

0

this is how I usually select and join between two or more different tables :

SELECT master_spaj._id,master_spaj.SPAJ_ID,pemegang_polis.nama_pp,table_tertanggung.nama_tt,master_spaj.IdProposal FROM master_spaj,pemegang_polis,table_tertanggung WHERE master_spaj.SPAJ_ID=pemegang_polis.SPAJ_ID AND master_spaj.SPAJ_ID=table_tertanggung.SPAJ_ID

answered Apr 04 '14 at 03:57

Menma

799
1
9
35

can u find problem in my query? why i am getting that exception – Sreekanth Apr 04 '14 at 04:20
have u try to implement my example code? – Menma Apr 04 '14 at 08:03
but i need to join table to get data – Sreekanth Apr 07 '14 at 12:57
sure, with this code, you can get data from multiple table. – Menma Apr 08 '14 at 02:43

score 0 · Accepted Answer · answered May 02 '14 at 06:32

0

Used queries to URL conversions.

OData v4 introduces a new operators, which may resolve your scenario.

For more please reference this:http://docs.oasis-open.org/odata/odata/v4.0/odata-v4.0-part2-url-conventions.html,

answered May 02 '14 at 06:32

Sreekanth

407
4
8
20

joining two tables in android sqlite

2 Answers2