update email_fax set ef_faxresult=22 where ci_fax='$user_extension' and ef_type=5 and ef_intftime=(select max(ef_intftime) from email_fax where ci_fax='$user_extension')错误代码是 you can't specify target table 'email_fax' for update in from clause帮帮忙 这么写不可以的话应该怎么写
分开写吧。
update email_fax,
(select max(ef_intftime) as max_intftime from email_fax where ci_fax='$user_extension') as email_fax1
set ef_faxresult=22 where ci_fax='$user_extension' and ef_type=5 and ef_intftime=max_intftime
不能这样写的主要原因在于,同一张表.