I磎 trying to update a table field using MySQL and PHP. The data source must be another field in another table. The sintaxe I am using is:
UPDATE A SET COD = (SELECT B.COD FROM A, B WHERE A.NAME = B.NAME)
Please, I'm waiting for reply!
Thanks!
Dennis
