[SQL] Unable to get a query to work

[stoneharry]

Thanks for taking the time to look at this question, I'll get straight into it:

DELETE FROM `gameobject_spawns` WHERE `entry` = (SELECT `entry` FROM `gameobject_names` WHERE `type` = '3');

Is what I am trying to do (delete from gameoject_spawns where the type in gameobject_names is = 3) but it is telling me:

Error Code : 1242
Subquery returns more than 1 row

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Error Code : 1242
Subquery returns more than 1 row

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Thanks.

[sasoritail]

I dont see any problems with the SQL Query.
What DataBase Editor are you using?

[stoneharry]

SQLyog Community Edition latest stable version, I was talking to somebody and he said there are a lot entrys and one query can not handle them all, although he doesn't know how to fix which is why I came here.

[Ground Zero]

Stone, Ill send you NaviCat Premium over msn.

[stoneharry]

Still failed using Navicat premium.

EDIT:

Executed:

DELETE FROM `gameobject_names` WHERE `type` = '3';
DELETE FROM `gameobject_spawns` WHERE `entry` NOT IN (SELECT `entry` FROM `gameobject_names`);

Which is a solution that works, but I would like to know how to get the original query working if anyone knows.

[sasoritail]

You sure you got a Gobject with the entry: 3 ?

[stoneharry]

You sure you got a Gobject with the entry: 3 ?

Not entry, type. Type 3 = Chests and veins etc. I'm trying to delete from gameobject_Spawns where the type in gameobject_names is 3.

[sasoritail]

Ahh ye... Well I'm Not Sure Why It Wont Work. Cant Help You Anymore.
Sorry

[Dynashock]

Use:

DELETE FROM `gameobject_spawns` WHERE `entry` IN (SELECT `entry` FROM `gameobject_names` WHERE `type` = '3');

[stoneharry]

I wuv you Dynashock <3

[sasoritail]

hmm i tested the Query you posted Stone and Dynashock's.... both worked for me on HeidiSQL.
I dont know whats wrong but your problem is solved so... yay

[Vision1000]

And all this time I thought stoneharry only answered questions.

=P