I have a table=table1 which consists 3 columns
columns1(data)
columns2(data)
columns3(no data but created)

Now I want to update the data in columns1 into columns3
My SQL statement like this:UPDATE table1 set Column3=Column1
Isn't correct?Thank Q

Last edited by lieweffect; 1Aug2006 at 14:23..