PDA

View Full Version : SQL Query Help ;D



LiLLeCarl
27-12-09, 11:08 AM
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

zlatko0o
04-02-10, 06:08 PM
I think you must do it manual