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]

Reply via email to