Description:
Table(A) Value Table(B) Value Table(c) Value
Name Branch Name Branch Name Branch
a1 aaa a1 aaa b2 aaa
a2 bbb a2 bbb b3 bbb
a3 vvv a3 vvv a1 vvv
a4 ddd a4 ddd c2 ddd
b2 eee b2 eee d2 eee
There are three tables A,B and C, each table contains two columns: Name and Branch. Column: Name is primary Key in all the Tables.
Table B is Child table to Table A.
I want to replace the values in column: Name in tables A and B with Value in Table C where Value in Column: Branch is Same as in Table A, Table B and Table C.
For example: The Value in column: Name is a1 in table A and table b B for Branch aaa, But in table C it is B2. I want to replace a1 with B2
Please not that Column: Name is primary key, the value B2 is already present in table A and table B for another entry(Last entry)
How to repeat:
Table(A) Value Table(B) Value Table(c) Value
Name Branch Name Branch Name Branch
a1 aaa a1 aaa b2 aaa
a2 bbb a2 bbb b3 bbb
a3 vvv a3 vvv a1 vvv
a4 ddd a4 ddd c2 ddd
b2 eee b2 eee d2 eee
There are three tables A,B and C, each table contains two columns: Name and Branch. Column: Name is primary Key in all the Tables.
Table B is Child table to Table A.
I want to replace the values in column: Name in tables A and B with Value in Table C where Value in Column: Branch is Same as in Table A, Table B and Table C.
For example: The Value in column: Name is a1 in table A and table b B for Branch aaa, But in table C it is B2. I want to replace a1 with B2
Please not that Column: Name is primary key, the value B2 is already present in table A and table B for another entry(Last entry)
