[sqlite] DATEADD?

2003-11-29 Thread Jake Skinner
This is a MySQL function, is there an equivalent? I couldn't find anything that resembles it. I expect that it is a MySQL specific thing but I thought I would ask people to be sure. Thanks Jake - To unsubscribe, e-mail: [EMAIL

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 -