title: How to update the data of some fields in one table based on the data of other field present on other table using LINQ or SQL?
body: <p>I have the following view and table in my project,</p>
  
  <p>vw_get_arabia_upod_full_details
  <img src="https://i.stack.imgur.com/pOOWL.jpg" alt="enter image description here"></p>
  
  <p>arabia_upod_item_avalability_master
  <img src="https://i.stack.imgur.com/j9yF6.jpg" alt="enter image description here"></p>
  
  <p>I want to update quantity and the total price present in vw_get_arabia_upod_full_details for each item_id based on maxAllowed in the same table and  availableQuantity present in arabia_upod_item_avalability_master. The availableQuantity is the total no. of quantity that is available. So I need to update quantity for each item checking maxAllowed and assigning maxAllowed (or less than that) to quantity till availableQuantity becomes zero. Could you help me? Thanks in advance.</p>