[SQL]delete items of a certain grade

[drachentypi]

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.

DELETE

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

some help would be nice

[Autrux]

#moved

[nubness]

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

[Autrux]

#closed as request