Question: how to copy data from one column to another in same table?
Answer: If it is a column for the same row that you want updated, the syntax is simpler: Update Table A Set Column1 = Column2. ...  The following example demonstrates how you can do it: ...  UPDATE TABLE SET COLUMN 1= COLUMN2; ...  Jack. ...  This is right if you are getting it from another table. ...  Hi,