How do you write SQL statement? The great spirit guide, please, I just contact, vb + Aceess2007 database, the database has A table A and table B, now you need to compare when the fields in table A and table B, the value of X (2 table field X data types is consistent, the field name) when they are equal, the Y field values in table A, B is inserted into A table in the Z field (including table A and table B Y fields of Z fields, field types).

CodePudding user response:

Update UpData set UpData. FEXP=(select the FFullName from Account, UpData the Where UpData. FACCTID=the FACCTID) I am writing, but an error, this tip , all files don't have write permissions problem, figure, or an error, is there any great god to know why,

CodePudding user response:

 update UpData, Account 
The set UpData. FEXP=Account. FFullName 
Where UpData. FACCTID=Account. FACCTID 

CodePudding user response:

When the update must write each table