On Fri, Mar 13, 2009 at 9:14 AM, Gilles Ganault <gilles.gana...@free.fr> wrote: > On Fri, 13 Mar 2009 09:52:25 -0400, "Igor Tandetnik" > <itandet...@mvps.org> wrote: > (snip) > > Thank you Igor for the help. Before I give it a shot, I need to speciy > those requirements: > 1. The tables live in two SQLite database files, so I must open both > in the same client session > 2. Each table may contain one or more records of the same company > > The goal is to create a third, new database file where companies are > unique, ie. a single record for each company.
assuming your "client" is the sqlite3 shell, 1. open db1 (new db) 2. attach db2 and db3 (old dbs) 3. follow Igor's directions > > Thank you. > > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from: Madison WI United States. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
