----- Original Message ----- > From: "Halász Sándor" <h...@tbbs.net> > > mysql> update address set membersince = (select membersince from > address where memberid = 1258) where memberid = 1724;
IIRC, subselects are allowed, except for selects that reference the table you're updating. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql