On 8/14/08, Bruce Martin <[EMAIL PROTECTED]> wrote: > Is there a way to link and do a select on multiple databases? > For example I have 3 databases maybe containing a list of file names. > > DB1 > Apple.txt > Grape.html > Cherry.txt > Peach.txt > > DB2 > Dell.txt > HP.txt > Gateway.txt > Apple.txt > > DB3 > > Apple Pie.txt > Cherry Pie.txt > Grape Jelly.txt > > > Now I want to select any record that starts with "apple" in all of the > databases.
You sure you mean "databases" when you might be meaning "tables"? Usually tables contain "lists", and a collection of related tables make up a database. Of course, you can also ATTACH disparate databases, but evaluate your strategy... you might be able to do with one db with three tables likes so CREATE TABLE fruits (id, name); CREATE TABLE computers (id, name); CREATE TABLE foods (id, name); Now you can select across tables SELECT * FROM fruits WHERE name LIKE '%apple%' UNION SELECT * FROM computers WHERE name LIKE '%apple%' UNION SELECT * FROM foods WHERE name LIKE '%apple%'; > > Thanks, > > Bruce Martin > The Martin Solution > [EMAIL PROTECTED] > http://www.martinsolution.com > http://externals.martinsolution.com > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
