Hi, MySql 4.0.14
How can I do this? Update Table1, Table2 set Table1.Field1 = Table2.Field1 + Table1.Field1 where Table1.KeyField = Table2.KeyField Tried the above with no success. Field1, in both tables is of type Text. regards ___________________________________________________________ ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]