Posted by Plamen Ratchev on 06/14/07 16:32

If you simply need to update the refno column to the values in the no
column, then you can write your update statement as follows:

UPDATE exp
SET refno = no

Note that this query does not have a WHERE clause and will update all rows.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: update one colum with other column value in same table using update table statement
• Prev in forum: Re: update one colum with other column value in same table using update table statement
• Thread view: Re: update one colum with other column value in same table using update table statement

[Reply to this message]