>UPDATE > TABLE_INV >SET > QTY = QTY + <THE QTY IN TABLE_DETAILS> >WHERE > WH_CODE IN (SELECT WH_CODE FROM TABLE_DETAILS) > AND ITEM_CODE IN (SELECT ITEM_CODE FROM TABLE_DETAILS) >>
>Table Name: Table_Inv >ID int >WH_Code varchar(10) >Item_Code varchar(10) >Qty int > > >Table Name: Table_Details >WH_Code varchar(10) >Item_Code varchar(10) >Qty qty > > > >Table_Inv >ID WH_Code Item_Code Qty >1 WH01 001 10 >2 WH01 002 20 >3 WH02 002 5 >4 WH02 003 6 >5 WH03 001 15 > >Table_Details >WH_Code Item_Code Qty >WH01 001 1 >WH01 002 2 >WH03 001 5 > > >Expected Result >Table_Inv >ID WH_Code Item_Code Qty >1 WH01 001 11 >2 WH01 002 22 >3 WH02 002 5 >4 WH02 003 6 >5 WH03 001 20 >>