Android : Join Query for multiple tables from different database

Question

In android apps we are using multiple databases (Sqlite). we need to use join query with two different tables from different databases. Can anybody have idea about this? If it is then can u please send the sample query for join two tables from different database?

Thanks Krishna

possible duplicate of SQLite - How do you join tables from different databases? — JRomero
– JRomero, Commented Nov 11, 2013 at 12:14

LS_ᴅᴇᴠ · Accepted Answer · 2013-11-11 15:46:32Z

1

attach database 'databaseObj1.db' as dbObj1;
attach database 'databaseObj2.db' as dbObj2;

select
  *
from
  dbObj1.Table1 a
inner join 
  dbObj2.Table2 b on b.Column = a.Column;

edited Nov 11, 2013 at 15:46

LS_ᴅᴇᴠ

11.2k1 gold badge27 silver badges46 bronze badges

answered Nov 11, 2013 at 14:47

Nagaraja

5811 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android : Join Query for multiple tables from different database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related