这句sql哪里错了，麻烦各分帮我分析，并改正一下谢谢。?报错

DELETE FROM `dandanv2_restore`.pw_user_wealth_history WHERE pro_type=1 AND TYPE IN(1,2) AND his_id > SELECT MAX(his_id) FROM `dandanv2_restore`.`pw_user_wealth_history_temp`;

这条数据报错，哪里错了呢？

报错代码

1 queries executed, 0 success, 1 errors, 0 warnings


查询：delete from `dandanv2_restore`.pw_user_wealth_history where pro_type=1 and type in(1,2) and his_id > select MAX(his_id) from `da...


错误代码： 1064
Erreur de syntaxe près de 'select MAX(his_id) from `dandanv2_restore`.`pw_user_wealth_history_temp`' à la ligne 1


执行耗时   : 0 sec
传送时间   : 0 sec
总耗时      : 0.067 sec