update A table to B table data.

Question

How to update A table data to  B table data.

 

for example : i taken 3 rows.but millions of records are there in table A and B

 and in Table B has more data than table A. 

 

TABLE A

 ______________________________________

Distributor Code|Product Code|Status|Value  |   

-------------------------------------------------------------- 

 110234                 |  23241         |     A    |  21      |

 231421                 |  45432         |    D     |  23     |

 343234                 |  32425         |    C     |  43      |

-------------------------------------------------------------- 

 

 TABLE B

______________________________________

Distributor Code|Product Code|Status|Value |

--------------------------------------------------------------

110234                 | 43241             | D       | 25   |

231421                 | 34432             | A       | 20  |

343234                 | 52425             | A       | 48   |

--------------------------------------------------------------

 

 

 * When i update with table A data into B table below is table is result

 

 

 

Expected Result IN Table B: 

______________________________________

Distributor Code|Product Code|Status|Value |

--------------------------------------------------------------

110234                | 23241              | A      | 21      |

231421                | 45432              | D      | 23      |

343234                | 32425              | C      | 43      |

--------------------------------------------------------------