select distince registno from prplwlog
where handlercode="4205016110"
and nodeno=2
and registno in (select l.registno from prplwlog l,prplregist r
where l.registno=r.registno
and r.reportdate<"2006-07-25"
and r.comcode[1,4]="4205"
and r.canceldate is null
and r.acceptflag="Y"
group by 1
having max(l.nodeno)=2)
流转系统中停于nodeno=2节点,且为XXX的案件信息
最新推荐文章于 2024-01-26 16:26:18 发布