Query Help

[bensonfactor]

Hey I need help with a query, I need to copy one column from a table into another, just the value,

the code that I need to use is:
update forum set oldthreadid = x where threadid = x

I just need to make them equal, but there are over 690 threads update, so I need a more efficent way.

[Xenon]

[SQL]UPDATE thread SET oldthreadid = threadid[/sql]

i'm sure you meant thread-table, because the forumtable does not have a threadid