Select across different databases
Select across different databases
Is it possible to do a select query based on columns in two different databases, i.e. two physically different files. I am using unidac but the underlying databases will be sqlite
Re: Select across different databases
Hello,
Yes, you can work with several databases simultaneously in one connection. For this, there is a command in SQLite - ATTACH DATABASE: http://www.sqlite.org/lang_attach.html .
Yes, you can work with several databases simultaneously in one connection. For this, there is a command in SQLite - ATTACH DATABASE: http://www.sqlite.org/lang_attach.html .