using tablename as alias
DELETE FROM tv_episodes USING tv_episodes AS ed LEFT OUTER JOIN data AS nd ON ed.file_name = nd.file_name AND ed.path = nd.path WHERE tv_episodes.id = ed.id AND ed.cd_name = ‘MediaLibraryDrive‘ AND nd.cd_name IS NULL;
原文：http://www.cnblogs.com/kevinge/p/5250899.html