Page 1 of 1
Select across different databases
Posted: Wed 09 Jul 2014 12:32
by sandy771
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
Posted: Wed 09 Jul 2014 14:47
by AlexP
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 .