Extract columns from two different database in sqlite3

Question

Is it possible to extract columns from two different database in sqlite3?

My problem is, I have two tables in two different database and I want to retrieve columns from tables from these two database.

To make it more clear, here is my pseudocode.

"SELECT Table_FromFirstDatabase.product 
 FROM MyFirstDatabase.Table_FromFirstDatabase
 WHERE   product NOT IN ('SELECT  Table_FromSecondDatabase.product 
                        FROM MySecondDatabase.Table_FromSecondDatabase');"

Is it possible to do something like this in sqlite3 ??

Thank you....

Benoit · Accepted Answer · 2011-06-06 14:24:25Z

1

You can do that:

ATTACH statements in SQLite.

Note that you could probably use SELECT t1.product FROM db1.tbl1 AS t1 EXCEPT (other select statement) instead of WHERE NOT IN

answered Jun 6, 2011 at 14:24

Benoit

79.7k24 gold badges226 silver badges241 bronze badges

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

Comments

Roland Mai · Accepted Answer · 2011-06-06 14:20:48Z

0

No. It's probably better for you to pull the data in a local list/array anyways.

answered Jun 6, 2011 at 14:20

Roland Mai

31.2k8 gold badges58 silver badges61 bronze badges

Collectives™ on Stack Overflow

Extract columns from two different database in sqlite3

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related