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

thx in advance


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to