SQL to copy parameters for a newly created code

[sncb]

HI there,

Not sure if this it the best place to ask the question but I created a few records with code and site as the main key parameters and I need to copy the rest of the parameters from the old codes to the new ones.

Any idea what the best SQL could be used for that?

Code	Site	Param1	Param2	Param3	Param4
A-Old	Loc1	Old param	Old param	Old param	Old param
B-Old	Loc1	Old param	Old param	Old param	Old param
A-new	Loc1	Old param	Old param	Old param	Old param
B-New	Loc1	Old param	Old param	Old param	Old param

<tbody>
</tbody>