MYSQL UPDATE

UPDATE A,C SET A.NAME=C.NAME WHERE A.ID=C.ID AND A.ID=2;