select max(tmp.ref_date)
from (select distinct items.item_code,
purpostdtl.item_code,
purpostdtl.ref_date
from items
left join purpostdtl
on items.item_code = purpostdtl.item_code
and purpostdtl.trx_price <> 0) as tmp
内容全部来源于网络收集，如有侵权，请联系网站删除!
QQ：24596024