Re: [sqlite] Querying 2 databases

2003-11-29 Thread Derrell . Lipman
Bronislav Klučka <[EMAIL PROTECTED]> writes: > Hi, > I've already asked this question, but nobody answered... > Is there any way how to ask 2 databases?? > "select db1.table1.id,db2.table9.name from db1.table1 left join db2.table9 > on db1.table1.id=db2.table9.id_object" See the documentation

Re: [sqlite] Querying 2 databases

2003-11-29 Thread D. Richard Hipp
Bronislav Klučka wrote: Hi, I've already asked this question, but nobody answered... Is there any way how to ask 2 databases?? "select db1.table1.id,db2.table9.name from db1.table1 left join db2.table9 on db1.table1.id=db2.table9.id_object" http://www.sqlite.org/lang.html#attach -- D. Richard

[sqlite] Querying 2 databases

2003-11-29 Thread Bronislav Klučka
Hi, I've already asked this question, but nobody answered... Is there any way how to ask 2 databases?? "select db1.table1.id,db2.table9.name from db1.table1 left join db2.table9 on db1.table1.id=db2.table9.id_object" Brona -