I have a table=table1 which consists 3 columns
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..