is it possible using mysql alone

Hi, I want to know if it is possible to do the following in Mysql 3.xx or do i have to write out a php script. table1 has a columns A,B,C table2 also has columns A,B,C. The data in column A is differnt in both tables (though 90% is identical) i want to update B,C in table2 where table1.A = table2.A. ANY CLUES ? here is what i tried - insert into table1 (B) select t1.B from table1 t1, table2 t2 where t1.A = t2.A THIS is only for column B- but it tells me i cant have table2 in the from clause thx in advance gamin.