PDA

View Full Version : Query Help


bensonfactor
12-13-2002, 07:26 PM
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
12-14-2002, 09:53 PM
UPDATE thread SET oldthreadid = threadid

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