help in query

10/01/2016 04:20 VsroHost#1

hello ,
iwant to delete gold coins from all who have more than 5000 gold coins ?

10/01/2016 04:26 AceSpace#2

Code:

UPDATE I
SET I.ItemID = 0
FROM SRO_VT_SHARD.dbo._Inventory I
JOIN SRO_VT_SHARD.dbo._Items IT
ON I.ItemID = IT.ID64
WHERE IT.RefItemID = 24670 AND IT.Data >= 5000