Hi, Try, mysql> delete from GbEntries where sender not in (select * from Accounts);
Thanks ViSolve DB Team. ----- Original Message ----- From: "Christian Parpart" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com> Sent: Wednesday, December 20, 2006 3:11 PM Subject: howto query DELETE <all records having invalid table refs> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]