> I would have thought your not = though is matching a lot more rows every > time..
The field is UNIQUE PRIMARY KEY in both tables, so there should be 0 or 1 matches. > I would look into using where not exists as a subselect My MySQL book (O'Reilly second edition) does not mention subqueries or EXISTS. I am reading about it online now. > delete from bar where not exists (select 'y' from foo where foo.phone = > bar.phone); > > something like that. Thanks, I'll give it a try. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
