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

Yes, the query is correct, but it does not make sense to use a subquery
here. See my other post for more simplified approach.

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: How to Gnerate a Random ID Number
• 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]