Try something like this: INSERT INTO table1 (common_field) SELECT common_field FROM table 2;
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 19, 2003 10:42 AM Subject: Updating table1 from table2 Hi: I am new to MySQL and can not find how to do this. I am running 4.0.16. Table1 has the correct values for a common field. Table 2 (the real one) needs to be updated from t1 via a common field. Can this be done with joins. And if not what is the best way. Thanks for any suggestions. _____ Douglas Denault [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
