>> What version of MySQL are you using? i use: mysql Ver 12.22 Distrib 4.0.18, for pc-linux-gnu (i386).
>> UPDATE t1, t2 SET t1.name=t2.name WHERE t1.id=1 AND t2.id=1; it works :), tnx again. -- >here are more things in heaven and earth, horatio, than are dreamt of in your philosophy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]