I'm a bit embarassed asking this here, but here goes:

I've got two tables, which you can see here:

http://img411.imageshack.us/img411/4562/query.jpg

I need to copy the effortid from the one table into the other, making sure that the values still maintain the correction relationships. The primary key for each is a combination of loggerid & datetime. What's the best way to do this?

Thanks in advance, and don't make fun :)