Archives of the TeradataForum

Message Posted: Fri, 12 Jan 2007 @ 11:28:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, January 12, 2007 05:52 -->

Hi,

When we try to do the below INSERT.. SELECT

     Insert into temp2 (value1, value2, value3)
     As
     Select (value1, valu2, value3) from temp1 order by value1

We get the following error

"3706: ORDER BY IS NOT ALLOWED IN SUB QUERIES"

I understand ORDER BY can't exist in the sub query.

But our intention is to generate a sequence number (in temp2) based on the 'value1' column in some order.

Can some one tell us, how to accomplish this ?

Thanks in advance

	<Prev	Next>		<<First	<Prev	Next>	Last>>