Re: [sqlite] Selecting over multiple databases

2004-06-14 Thread D. Richard Hipp
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

Re: [sqlite] Selecting over multiple databases

2004-06-14 Thread Mateusz Łoskot
On 6/14/2004 4:05 PM, Richard Boehme wrote: Hi there. I'm thinking of putting some data into two separate databases (user info and tracking info). > Why ? Strande solution ;-) It user info and tracking info are related entities, why you want to store it separately ? Is this possible with SQLite?

[sqlite] Selecting over multiple databases

2004-06-14 Thread Richard Boehme
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 database