Update a field in a table with a field in the same table

  • Thread starter Thread starter Guest
  • Start date Start date
It would have been nice if you would have taken the time to enter some
sample records with table and field names. However, you can try

UPDATE tblA
SET FieldA = FieldB;
 
Update Tablename (Field1) Values (Field2)

Is this the SQL? Or what I put in the UPDATE condition?
 
Steve's SQL statement is most often used to update a single record. Is this
what you want to do? Did you try my suggestion?
 
Back
Top