FROM wf_task t , wf_process p ,wf_stepType s
WHERE t.processID = p.id
and t.stepType = s.id
and t.status='2'
and p.status!='4'
and p.status!='5'
and p.processType='公文处理_发文_办公室流程'
and p.processType='公文处理_发文_办公室流程'
and p.processType LIKE '公文处理%'
and exists(select title from OA_doc_meetingContentwhere title='808' union select title from OA_doc_mainInfo where title='808' )
order by tDate desc
WHERE t.processID = p.id
and t.stepType = s.id
and t.status='2'
and p.status!='4'
and p.status!='5'
and p.processType='公文处理_发文_办公室流程'
and p.processType='公文处理_发文_办公室流程'
and p.processType LIKE '公文处理%'
and exists(select title from OA_doc_meetingContentwhere title='808' union select title from OA_doc_mainInfo where title='808' )
order by tDate desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货