At 17:10 -0500 3/7/03, Christopher M Burger wrote:
>I'm trying to write a query that would update a field in a table. Here is
>Table 1 has two fields - field A and Field B
>Table 2 has two fields - field A and Field B
>Each table has many more fields but these are the only two I'm concerned
>with right now.
>Field B in table 2 is empty. Field B in table 1 is filled. Field A is
>filled in both tables. What I would like to do is set field B in table 2 to
>the value of field B in table 1 where field A in table 2 is equal to field A
>in table 1.
>Any help would be appreciated.
UPDATE t1, t2 SET t2.B = t1.B WHERE t2.A = t1.A;
Requires MySQL 4.0.2.