Update records using update_recordset command in MSD axapta

Example of update_recordset.

 update_recordset InventItemInventSetup  setting standardQty = 5667  
     join itemId,itemType from inventTable where InventItemInventSetup.ItemId == inventTable.ItemId  && inventTable.ItemType == itemType::BOM;