Burda yoktu Paylaşmak istedim :) USE SRO_VT_SHARD DELETE _RefDropItemAssign FROM _RefDropItemAssign Drops LEFT JOIN _RefObjCommon Objects ON (Drops.RefItemID = Objects.ID) WHERE CodeName128 like 'İTEMİN KODU'