On Tue, Apr 1, 2008 at 3:34 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > According to the manual multi-table UPDATE and DELETE queries can use > explicit join syntax, but I have had issues with that in the past, and only > achieved success using implicit (comma) joins. YMMV.
Hmm. Are your issues solved by the suggestions in this post? http://www.xaprb.com/blog/2006/08/07/how-to-write-multi-table-cross-database-deletes-with-aliases-in-mysql/ Baron -- Baron Schwartz, Senior Consultant, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]