Re: [sqlite] Database merge?

2006-01-27 Thread Dennis Cote
michael munson wrote: >I have two databases, one has many fields I need, the other only has one. Is >it possible to go through the second database, and update specific rows on the >first? > >DB1 has many rows, and DB2 has some. Every row in DB2 is in DB1 and they both >have the same value for

Re: [sqlite] Database merge?

2006-01-26 Thread Darren Duncan
At 11:20 PM -0600 1/26/06, michael munson wrote: I have two databases, one has many fields I need, the other only has one. Is it possible to go through the second database, and update specific rows on the first? DB1 has many rows, and DB2 has some. Every row in DB2 is in DB1 and they both

[sqlite] Database merge?

2006-01-26 Thread michael munson
I have two databases, one has many fields I need, the other only has one. Is it possible to go through the second database, and update specific rows on the first? DB1 has many rows, and DB2 has some. Every row in DB2 is in DB1 and they both have the same value for the key row so they can be