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