[SQL]delete items of a certain grade

05/01/2014 14:05 drachentypi#1

Hello people of ePvP,
I tried to delete items of a certain grade from dbo.CharItems.
I'm a beginner in SQL so I wrote this easy statement which don't worked.

Code:

DELETE

FROM [PS_GameData].[dbo].[CharItems]
Where ItemID in ( SELECT Grade FROM [PS_GameDefs].[dbo].[Items] Where Grade = 1)

some help would be nice :)

05/01/2014 14:56 Autrux#2

#moved

05/01/2014 15:40 nubness#3

Code:

DELETE PS_GameData.dbo.CharItems
WHERE ItemID IN (SELECT ItemID FROM PS_GameDefs.dbo.Items WHERE Grade = 1)

05/01/2014 23:31 Autrux#4

#closed as request