> I guess I have to do it in PHP, eh? nope ;o) UPDATE tableA INNER JOIN tableB ON tableB.fk = tableA.fk SET tableB.datafield = tableA.datafield -- rudy http://r937.com/