On Sun, Mar 14, 2010 at 6:01 PM, David Lyon <david_ly...@yahoo.com> wrote: > if I had a database called db1 with table tbl1 with field id and a second db > called db2 and a table called tbl2 with field id, whats the correct syntax to > query across the 2 databases eg: > > "select * db1..tbl1 a , db2..tbl2 b where a.id=b.id" > > This doesnt work, can someone modify it to work? >
You can't query across two separate databases with one db connection, because a connection is to one db at a time. You can ATTACH the second db to the first db, and then, for all purposes, you have one db within which you can make queries across tables. > > Thanks for your help in advance. > > > Dave > > > -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
