mysql> delete from quotes2 -> where id in ( -> select quotes2.id from quotes2 -> join quotes on quotes2.quote = quotes.quote); ERROR 1093 (HY000): You can't specify target table 'quotes2' for update in FROM clause