SQLite Forum

Query 2 databases
Login
Hi, ALL,

Lets say I opened a connection to a database and want to attach a second database.

Lets call connected DB a conn.db and attached one - att.db.

Will I be able to do an inter-DB query?

If yes - what would be the syntax?

[code]
SELECT conn.table1.field1, att.table2.field2 FROM conn.table1, att.table2 WHERE conn.table1.id = att.table2.id;
[/code]

Or something different?

Thank you.