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?

[TABLE="width: 552"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Site[/TD]
[TD]Param1[/TD]
[TD]Param2[/TD]
[TD]Param3[/TD]
[TD]Param4[/TD]
[/TR]
[TR]
[TD]A-Old[/TD]
[TD]Loc1[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[/TR]
[TR]
[TD]B-Old[/TD]
[TD]Loc1[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[/TR]
[TR]
[TD]A-new[/TD]
[TD]Loc1[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[/TR]
[TR]
[TD]B-New[/TD]
[TD]Loc1[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[TD]Old param[/TD]
[/TR]
</tbody>[/TABLE]