[sqlite] Re: Novice Question about SQLite Insert Command

viking2 <[EMAIL PROTECTED]> wrote: I will first copy TB_SignatureRecords using the following command: insert into TB_Signature select "",nFileSignature,0,nFileDate from TB_SignatureRecords; What I need help with is the command for merging the second table: from TB_FileRecords: pszFilename rep

[sqlite] Re: Novice Question about SQLite Insert Command

viking2 <[EMAIL PROTECTED]> wrote: I have a database (*.db3) with 3 tables: CREATE TABLE TB_Signature (Filename TEXT, FileSignature TEXT, FileSize INTEGER, FileDate INTEGER, PRIMARY KEY (FileSignature,FileSize)); CREATE TABLE TB_FileRecords (pszFilename TEXT PRIMARY KEY, nFileSize INTEGER, nFil