Required items

[Shadow-Wolf]

Originally Posted by AndMetal

I'm sure the syntax is 100% correct, but you should be able to do something like this:

DELETE FROM items 
	WHERE id NOT IN (
		(SELECT components1 FROM spells_new WHERE components1 > 1000), 
		(SELECT components2 FROM spells_new WHERE components2 > 1000), 
		(SELECT components3 FROM spells_new WHERE components3 > 1000), 
		(SELECT components4 FROM spells_new WHERE components4 > 1000), 
		(SELECT NoexpendReagent1 FROM spells_new WHERE NoexpendReagent1 > 1000), 
		(SELECT NoexpendReagent2 FROM spells_new WHERE NoexpendReagent2 > 1000), 
		(SELECT NoexpendReagent3 FROM spells_new WHERE NoexpendReagent3 > 1000), 
		(SELECT NoexpendReagent4 FROM spells_new WHERE NoexpendReagent4 > 1000)
	)

With a little modification adding the fields Cavedude specified this will give me exactly what I needed. Thank you everyone for your help!