Update tbl_product_store set Store_Remain=tbl_product_store.Store_Remain + @quantity  from tbl_product_store inner join tbl_product_sale_market_final on tbl_product_sale_market_final.Barcode = tbl_product_store.Barcode WHERE tbl_product_sale_market_final.Barcode=@Barcode AND tbl_product_sale_market_final.No=@No