Okay, it would help if I was running a "delete query" I suppose. But even then, a direct copy and paste of those lines above I get "You are about to delete 0 records". I fiddled around with the line and tried just "not in (select playerid from batting where teamid in ('mil','ml1','ml2','ml3','ml4','mlu','se1'))" and that's running now... not sure if its running correctly, however.