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 replaces 1st column in TB_Signature
nFileSize replaces 3rd column in TB_Signature
update TB_SignatureRecords set
Filename = (select pszFilename from TB_FileRecords where nFileSignature
= FileSignature),
FileSize = (select nFileSize from TB_FileRecords where nFileSignature =
FileSignature);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
