SQL DELETE with INNER JOIN

Question

There are 2 tables, spawnlist, and npc, and I need to delete data from spawnlsit. npc_templateid = n.idTemplate is the only thing that "connect" the tables. I have tried this script but it doesn't work.

I have tried this:

DELETE s FROM spawnlist s

INNER JOIN npc n ON s.npc_templateid = n.idTemplate

WHERE (n.type = "monster");

Answer 1

Try adding .* to s in your first line of code like this:

DELETE s.* FROM spawnlist s

INNER JOIN npc n ON s.npc_templateid = n.idTemplate

WHERE (n.type = "monster");