Yes, databases. The databases are generated by another process but I need to search all of them for matches.
Bruce Martin The Martin Solution [EMAIL PROTECTED] http://www.martinsolution.com http://externals.martinsolution.com On Aug 14, 2008, at 11:51 AM, P Kishor wrote: > 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
