Use this
UPDATE _RefObjItem SET Param1 = 0 WHERE ID IN
(SELECT LINK FROM _RefObjCommon WHERE TypeID1 = 3 and TypeID2 = 3 and TypeID3 = 10 and TypeID4 = 4)
or
USE [SRO_VT_SHARD]
GO
UPDATE _RefObjItem
SET _RefObjItem.Param1 = 0
FROM _RefObjItem AS Items
INNER JOIN _RefObjCommon AS Objects
ON Items.ID=Objects.Link
WHERE CodeName128 like '%ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_%_%_%'