> What I want to do is copy datafield from table A to table B, per the > fk field. To be clear, once it's done the value of datafield in A will > match that in B for fk value 1, and again for value 2, 3 etc. I guess I have to do it in PHP, eh? Could be a subselect would work but PHP also works. OK :)