Posted by Manikandan on 06/14/07 16:21

Hi,
I have table with three columns as below
table name:exp
No(int) name(char) refno(int)

I have data as below
No name refno
1 a
2 b
3 c

I need to update the refno with no values I write a query as below

update exp set refno=(select no from exp)
when i run the query i got error as
Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used as
an expression.

I need to update one colum with other column value.
What is the correct query for this ?

Thanks,
Mani

• Next in forum: Re: update one colum with other column value in same table using update table statement
• Prev in forum: Using SSIS to backup/restore databases
• Thread view: update one colum with other column value in same table using update table statement

[Reply to this message]