I've got a conundrum in that MySQL < 4.1 does not support subqueries. Is there another way to do a query such as this one below without upgrading?: update t1 set repname = (select t2.value from t1 where t2.attributeid = '4' and t2.userid = t1.id) cheers, Mark