Re: Updating table1 from table2

2003-12-19 Thread Egor Egorov
[EMAIL PROTECTED] wrote: > > 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.

Re: Updating table1 from table2

2003-12-18 Thread Terence
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

Updating table1 from table2

2003-12-18 Thread doug
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. _ Do