这个语句，如何改写优化？

ZALBB

ORACLE 11204,


红色部分的关联字段，都不唯一，


(select t0.FPRODUCTID,t0.FMATERIALID,t0.FEXPTYPE,t0.FLINEDATATYPE,t0.FCOSTITEMID,t0.FEXPENSEITEMID,t0.FSELECTTYPE, t0.fdiffusedhour,t0.fdiffprice,t0.fdiffcostamount,t0.FDIFFAMOUNT
from TM_A t0
where t0.fcurrcostamount=0
   and t0.fdiffcostamount<>0
   and exists (select 1 from TM_A where FNeedRestore=1 and FMATERIALID>0 and FMATERIALID=t0.FPRODUCTID) )

ZALBB

select t0.FPRODUCTID,t0.FMATERIALID,t0.FEXPTYPE,t0.FLINEDATATYPE,t0.FCOSTITEMID,t0.FEXPENSEITEMID,t0.FSELECTTYPE, t0.fdiffusedhour,t0.fdiffprice,t0.fdiffcostamount,t0.FDIFFAMOUNT
from TM_A
where fcurrcostamount=0
   and fdiffcostamount<>0
   and FNeedRestore=1
   and FMATERIALID>0
   and FMATERIALID=FPRODUCTID

感觉可以改成这样，

richto

No, if FMATERIALID=t0.FPRODUCTID is not unique identifying a record.