I tried getting ATTACH to work since this am (EST) and have been looking in the different sqlite forums but have yet to find a simple and clear description of how to get this to work.
I have the ARGS1_DB and contains args table. when I attach the ARGS1_DB to db1, I dont get the args table from ARGS1_DB in db1. any ideas? Apologies for the inconvenience. sqlite3 ARGS1_DB "select * from args" | more 1|1 2|2 3|3 4|4 5|5 6|6 7|7 8|8 sqlite3 db1 "attach ARGS1_DB as db1" sqlite3 db1 "select * from args" SQL error: no such table: args sqlite3 db1 "select * from db1.args" SQL error: no such table: db1.args --- On Sun, 3/14/10, Jay A. Kreibich <j...@kreibi.ch> wrote: > From: Jay A. Kreibich <j...@kreibi.ch> > Subject: Re: [sqlite] syntax for sqlite to query across 2 databases > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Sunday, March 14, 2010, 9:37 PM > On Sun, Mar 14, 2010 at 06:22:15PM > -0700, David Lyon scratched on the wall: > > > Can you or someone provide the exact syntax for ATTACH > > > > http://www.lmgtfy.com/?q=sqlite+attach+command&l=1 > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users