[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.
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
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