Richard Boehme wrote:
Hi there. I'm thinking of putting some data into two separate databases
(user info and tracking info). However, if I did that, I would need to
do some SELECT statements across both databases (select with two tables
with a common identifier in both tables; the tables are in two separate
databases).
Is this possible with SQLite? If so, can anyone point me to how to do it?
Yes, you can do this.
Open one database using sqlite_open(). Use the ATTACH command
to connect the second database. Then you'll be able to do joins
that use tables from both databases.
http://www.sqlite.org/lang.html#attach
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
