update A table to B table data.

raviteja sridasyam

10y993

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 |

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Accepted answer
Try with below SQL query:

UPDATE B
SET B.ProductCode = A.ProductCode,
B.Status = A.Status,
B.Value = A.Value
FROM TableB B INNER JOIN TableA A
ON B.DistributorCode = A.DistributorCode

+2
raviteja sridasyam10y ago
@Manas Mohapatra : how can we write "IF exist" statement for this query. for example in b table some data is same as a table. then it should change only different data. how can we put "IF exist" statement because i need to check weather the data is already in b table are not. can u help me to involve "IF exist" statement into this query.
0
Manas Mohapatra10y ago
If you want update one row then use filtering:

UPDATE B
SET B.ProductCode = A.ProductCode,
B.Status = A.Status,
B.Value = A.Value
FROM TableB B INNER JOIN TableA A
ON B.DistributorCode = A.DistributorCode

WHERE B.DistributorCode = 231421;
+2
raviteja sridasyam10y ago
@Manas Mohapatra : for this can how write where exist statement. for example in b table some data is same in a table then it should change only different data in this query how can we put where exist statement because i need to check weather the data is already in b table are not. can u help me to involve where exist statement into this query.
+1
raviteja sridasyam10y ago
Thank you so much Manas Mohapatra your query is working . and one more if i need to update only one row then how ?
0