copy info from one field and append to another

[sammybee77]

Hi

I am looking to write a script that will take the information from one field and add it to the information already held in a comments(not overwrite it) - Any idea how I would do this?

Many thanks

Sam

 

[lewisp]

:block1.field1 := :block1.field1 || :block1.field2;

 

[jimbopalmer]

Update mytable set comment = comment||' '||otherfield I tried to remain child-like, all I acheived was childish.

 

[sammybee77]

Is it possible to do an update like this where I take the data from one table and append to the data in another table?

Many thanks

Sam

 

[Dagon]

update table1 t1 set column1 =
(select t1.column1||t2.column2
from table2 t2
where t1.key = t2.key)
where exists
(select t1.column1||t2.column2
from table2 t2
where t1.key = t2.key)