It seems to work like I wished, thank you very much.:-D

I appreciate the help in this forum, and I'm sorry I can't show more precisely info about my problem, like I sayed before, no Internet at my job.

I need to update only one column in my second table, for each row in the tmp table I should concatenate ',' + the value from the field from the...

unfortunately I am writing from home and have no Internet at work.

Yes , I need to update exsiting data

10ks for your replies.

I need to use update and not insert to.

I will try to explain myself better.

this is my tmp table:

ID val_1 val_2

1 somthing 26

1 somthing 31

2 somthing 25

3...