> UPDATE tableA > INNER > JOIN tableB > ON tableB.fk = tableA.fk > SET tableB.datafield = tableA.datafield Ah beautiful. Thanks. I responded to my own post after a day and then later realized that it was never post--my post and response seem to have gone through at the same time. Anyway, thanks.