Does anyone know the query to copy column data from one table and put it in another

Try something like that:

Hope this helps.

why would you want to copy a value from one table to another?

will that query lose my original values? I would like to recreate them without losing my original values.


I want to copy them because I am running a new application that calls for some but not all of the same data columns. As this is a stand alone app I found it to be more concise and practical to have it draw its data from a seperate table

No, the original values will be untouched. Suggest you back up both before experimenting because if you get something crossed, you could update what you do not intend. . .

I finally got it. Here was the code that ended up working

UPDATE table1 SET table1.column=table2.somecolumn
FROM table1, table2
WHERE table1.anothercolumn = table2.yetanothercolumn;

Please use JOIN syntax:

UPDATE table1 SET table1.column=table2.somecolumn
FROM table1
inner join table2 on table1.anothercolumn = table2.yetanothercolumn;