SQL Query Help ;D

[LiLLeCarl]

delete from creature_proto where entry != creature_names.entry;
delete from creature_proto where entry != (select entry from creature_names);




something like that is what i can imagine its supposed to remove all entrys from creature_proto that doesent have a entry in creature_names well tthats it

SOLUTION:
delete from creature_proto where entry NOT IN (select entry from creature_names);

// LilleCarl ;D

---

› See More: SQL Query Help ;D

[zlatko0o]

I think you must do it manual