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 | --------------------------------------------------------------

Manas Mohapatra · 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

Manas Mohapatra · Answer

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;

raviteja sridasyam · Answer

@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.

raviteja sridasyam · Answer

@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.

raviteja sridasyam · Answer

Thank you so much Manas Mohapatra your query is working . and one more if i need to update only one row then how ?