mysql语句报错了，求解决
DELETE from sys_paybycps where payid in(SELECT a.payid FROM sys_paybycps a RIGHT JOIN sys_membersbycps ON a.username=b.username where b.channelid='11' AND pay_time BETWEEN '1389651211' and '1389691287');


报错：You can't specify target table 'sys_paybycps' for update in FROM clause

我应该怎么写勒

[解决办法]
如果删除的记录太多，可以新建1个表